Why is my name on a mail from Tom Lane ? Really, he knows a *lot* more than I and
should get due credit.
Seriously, is this the peformance remailer mangling something ?
Greg Williamson
(the real one)
-Original Message-
From: Gregory S. Williamson
Sent: Sun 6/6/2004 10:46 PM
To:
Sean Shanny <[EMAIL PROTECTED]> writes:
> We have the following setting for random page cost:
> random_page_cost = 1# units are one sequential page fetch cost
> Any suggestions on what to bump it up to?
Well, the default setting is 4 ... what measurements prompted you to
reduce it to 1
John Siracusa <[EMAIL PROTECTED]> writes:
> I want to do something that will convince Postgres that using the date
> index is, by far, the best plan when running my queries, even when the
> date column correlation stat drops well below 1.0.
Have you tried experimenting with random_page_cost?
Hi, Steve,
On Sat, 05 Jun 2004 13:12:29 -0700
Steve Wampler <[EMAIL PROTECTED]> wrote:
> I've got a simple database (no indices, 6 columns) that I need
> to write data quickly into through JDBC connections from
> multiple such connections simultaneously in a distributed
> environment. (This is g
> The members table contains about 500k rows. It has an index on
> (group_id, member_id) and on (member_id, group_id).
Yes, bad stats are causing it to pick a poor plan, but you're giving it
too many options (which doesn't help) and using space up unnecessarily.
Keep (group_id, member_id)
Remov
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> Laurent Martelli <[EMAIL PROTECTED]> writes:
>> Now, if I use the following view to abstract access rights:
>> CREATE VIEW userpictures (
>> PictureID,RollID,FrameID,Description,Filename,
>> Owner,EntryDate,Date,
>> NbClick,NbRa
Laurent Martelli <[EMAIL PROTECTED]> writes:
> Now, if I use the following view to abstract access rights:
> CREATE VIEW userpictures (
>PictureID,RollID,FrameID,Description,Filename,
>Owner,EntryDate,Date,
>NbClick,NbRates,MaxRate,MinRate,AverageRate,SumRates,
>Use
Hello again,
This question is related to my previous one (Unused table of view, see
http://archives.postgresql.org/pgsql-performance/2004-06/msg00043.php).
For the moment, I have queries where I join tables by hand. Since a
few tables are always joined together, I thought I could define a view
to
In article <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]> writes:
> Hi All,
> I am using Linux 7.2 and postgresql 7.2.
> Our Office hours are over at 6pm but we use to keep our server
> running 24 hours a day. On the second day morning, Our PGSQL
> Server becomes very slow.
> After continuous usage
