Tom Lane wrote:
Could be. I went back to look at Sam Mason's report about three weeks
ago, and it definitely seems to explain his issue.
I've just built a patched version as well and it appears to be doing
what I think is the right thing now. I.e. actually picking the
plan with the lower cost.
pgsql performance gurus,
I sent the following message earlier this week. I have continued
attempting to find something on the net that would explain this
strange change of query plans, but nothing seems to apply.
Are there any thoughts, such as possibly tweaking the database
somehow to see if I
It's likely that data is in filesystem (not database) cache the second time you
run the query. See if the same thing happens when you stop and restart the
postmaster (it likely wont), then do something like this to flush the
filesystem cache (read a big file, can't give you a sample cmd
I've now backed off to version 7.4.1, which doesn't exhibit the problems that
8.0.3 does. I guess I'll wait 'till the next version and see if any progress
has occurred.
Rob
When grilled further on (Tue, 19 Jul 2005 22:49:08 -0600),
Robert Creager [EMAIL PROTECTED] confessed:
When grilled
Joshua,
On 7/22/05 10:11 AM, Joshua D. Drake [EMAIL PROTECTED] wrote:
The database server is a PE (Power Edge) 6600
Database Server IO:
[EMAIL PROTECTED] root]# /sbin/hdparm -tT /dev/sda
/dev/sda:
Timing buffer-cache reads: 1888 MB in 2.00 seconds = 944.00 MB/sec
Timing
Title: Re: [PERFORM] Looking for tips
Hi,
I have a similar application,
but instead of adding new items to the db once at time,
Iretrieve new IDs from a sequence (actually only every 10'000
times) and write a csv file from perl.
When finished, I load all new record in one run with Copy.
Mark,
On 7/22/05 12:47 PM, Mark Wong [EMAIL PROTECTED] wrote:
On a single spindle:
$ time dd if=/dev/zero of=bigfile bs=8k count=200
200+0 records in
200+0 records out
real2m8.569s
user0m0.725s
sys 0m19.633s
This is super fast! 124MB/s seems too fast for true
Hello,
I'm searching for two facts:
How much space takes a varchar column if there is no value in it (NULL)?
How much space needs a index of an integer column?
Hope I post to the right list and hope anybody can help me.
Thank you
Greetings
Achim
---(end of