On Tuesday 21 September 2004 00:01, Patrick Hatcher wrote:
> Hello.
> Couple of questions:>
> - Q1: Today I decided to do a vacuum full verbose analyze on a large table
> that has been giving me slow performance. And then I did it again. I
> noticed that after each run the values in my indexes an
Hello.
Couple of questions:
- Q1: Today I decided to do a vacuum full verbose
analyze on a large table that has been giving me slow performance. And
then I did it again. I noticed that after each run the values in my
indexes and estimate row version changed. What really got me
wond
A recent comment on this (or perhaps another?) mailing list about Sun boxen
and the directio mount option has prompted me to read about O_DIRECT on the
open() manpage.
Has anybody tried this option? Ever taken any performance measurements?
I assume the way postgres manages its buffer memory (deali
On Fri, 17 Sep 2004 19:23:44 -0500, Stephen Crowley
<[EMAIL PROTECTED]> wrote:
>Seq Scan [...] rows=265632
> Filter: ((date = '2004-09-07'::date) AND ((stock)::text = 'MSFT'::text))
>Total runtime: 412703.000 ms
>
>random_page_cost and effective_cache_size are both default, 8 and 1000
Usually ran