Thomas F.O'Connell wrote:
As a result, I was intending to inflate the value of
effective_cache_size to closer to the amount of unused RAM on some of
the machines I admin (once I've verified that they all have a unified
buffer cache). Is that correct?
Effective cache size is IMHO a "bogus" param
Mallah,
> Gist indexes take a long time to create as compared
> to normal indexes is there any way to speed them up ?
>
> (for example by modifying sort_mem or something temporarily )
More sort_mem will indeed help. So will more RAM and a faster CPU.
Our GIST-index-creation process is probably
Hi ,
Gist indexes take a long time to create as compared
to normal indexes is there any way to speed them up ?
(for example by modifying sort_mem or something temporarily )
Regds
Mallah.
---(end of broadcast)---
TIP 9: the planner will ignore yo
Many thanks to Chariot Solutions, http://chariotsolutions.com, for hosting
Bruce Momjian giving one of his PostgreSQL seminars outside of
Philadelphia, PA yesterday. There were about sixty folks there, one person
driving from Toronto and another coming from California (!).
I found it very enlight
Ð ÐÑÐ, 27.10.2004, Ð 09:57, TTK Ciar ÐÐÑÐÑ:
> brad=# explain analyse select
> ServerDisks.servername,ServerDisks.diskserial,ServerDisks.diskmountpoint,DiskFiles.name,DiskFiles.md5
> from DiskFiles,ServerDisks where DiskFiles.diskserial=ServerDisks.diskserial;
> QUERY PL