Search Postgresql Archives

Re: Best practice to get performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 11/19/10 23:14, Andy Colson wrote:
On 11/19/2010 4:04 PM, Ivan Voras wrote:
On 11/19/10 15:49, Andy Colson wrote:

unlogged will only help insert/update performance. Lookup tables sound
readonly for a majority of time. (I'm assuming lots of reads and every
once and a while updates). I doubt that unlogged tables would speed up
lookup tables.

Are FreeBSD's temp tables still storage-backed? (i.e. are there
memory-backed temp tables)?




Sorry, I'm not sure what you are asking. Not sure what this has to do
with FreeBSD, or its temp tables.

Unless: s/freebsd/postgres/i

Yes, sorry, switched between mailing lists too fast :)

Ah, yes, Postgres temp tables still make it to disk eventually. They are
not WAL logged (but if they get really big they spill to disk). There
are no memory only tables, no. But PG will cache the heck out of all
tables, so you get the best of both worlds.

Thanks!


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux