От: Alvaro Herrera
Тема: Re: Number of tables
Дата: ,
Msg-id: 20090821003854.GT6261@alvh.no-ip.org
(см: обсуждение, исходный текст)
Ответ на: Re: Number of tables  (Greg Stark)
Ответы: Re: Number of tables  (Greg Stark)
Re: Number of tables  (Robert Haas)
Список: pgsql-performance

Скрыть дерево обсуждения

Getting time of a postgresql-request  ("Kai Behncke", )
 Re: Getting time of a postgresql-request  (Russell Smith, )
  Re: Getting time of a postgresql-request  (Pierre Frédéric Caillaud<>, )
 Number of tables  (Fabio La Farcioli, )
  Re: Number of tables  (Jochen Erwied, )
  Re: Number of tables  (Craig Ringer, )
   Re: Number of tables  (Fabio La Farcioli, )
  Re: Number of tables  (Craig James, )
   Re: Number of tables  (Greg Stark, )
    Re: Number of tables  (Craig James, )
     Re: Number of tables  (Greg Stark, )
      Re: Number of tables  (Alvaro Herrera, )
       Re: Number of tables  (Greg Stark, )
        Re: Number of tables  ("Kevin Grittner", )
       Re: Number of tables  (Robert Haas, )
      Re: Number of tables  (Jerry Champlin, )
  Re: Number of tables  (Mike Ivanov, )
   Re: Number of tables  (Greg Stark, )
    Re: Number of tables  (Mike Ivanov, )

Greg Stark wrote:

> It would be nice to have a solution to that where you could create
> lightweight temporary objects which belong to an "application session"
> which can be picked up by a different database connection each go
> around.

It would be useful:

CREATE SCHEMA session1234 UNLOGGED
  CREATE TABLE hitlist ( ... );

Each table in the "session1234" schema would not be WAL-logged, and
would be automatically dropped on crash recovery (actually the whole
schema would be).  But while the server is live it behaves like a
regular schema/table and can be seen by all backends (i.e. not temp)

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


В списке pgsql-performance по дате сообщения:

От: Jeff Janes
Дата:
Сообщение: [PERFORMANCE] how to set wal_buffers
От: gael@pilotsystems.net (Gaël Le Mignot)
Дата:
Сообщение: Performance regression between 8.3 and 8.4 on heavy text indexing