-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, May 09, 2005 2:23 PM
To: pgsql-performance@postgresql.org
Subject: [PERFORM] PGSQL Capacity
How can i know a capacity of a pg database ?
How many records my table can have ?
I saw in a message that
-Original Message-
From: Josh Berkus [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 27, 2005 10:25 AM
To: Andrew Dunstan
Cc: Mischa Sandberg; pgsql-perform; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] [PERFORM] Bad n_distinct estimation; hacks
suggested?
[...]
-Original Message-
From: Shoaib Burq (VPAC) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 26, 2005 9:31 AM
To: Tom Lane
Cc: John A Meinel; Russell Smith; Jeff;
pgsql-performance@postgresql.org
Subject: Re: [PERFORM] two queries and dual cpu (perplexed)
OK ... so just to
-Original Message-
From: Gurmeet Manku [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 26, 2005 5:01 PM
To: Simon Riggs
Cc: Tom Lane; josh@agliodbs.com; Greg Stark; Marko Ristola;
pgsql-perform; pgsql-hackers@postgresql.org; Utkarsh Srivastava;
[EMAIL PROTECTED]
Subject: Re:
-Original Message-
From: Josh Berkus [mailto:[EMAIL PROTECTED]
Sent: Sunday, April 24, 2005 2:08 PM
To: Andrew Dunstan
Cc: Tom Lane; Greg Stark; Marko Ristola; pgsql-perform;
pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] [PERFORM] Bad n_distinct estimation; hacks
suggested?
-Original Message-
From: Andrew Dunstan [mailto:[EMAIL PROTECTED]
Sent: Monday, April 25, 2005 3:43 PM
To: josh@agliodbs.com
Cc: pgsql-perform; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] [PERFORM] Bad n_distinct estimation; hacks
suggested?
Josh Berkus wrote:
Simon,
-Original Message-
From: Alex Turner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 20, 2005 12:04 PM
To: Dave Held
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] How to improve db performance with $7K?
[...]
Lets say we invented a new protocol that including
-Original Message-
From: Alex Turner [mailto:[EMAIL PROTECTED]
Sent: Monday, April 18, 2005 5:50 PM
To: Bruce Momjian
Cc: Kevin Brown; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] How to improve db performance with $7K?
Does it really matter at which end of the cable
-Original Message-
From: Josh Berkus [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 19, 2005 2:09 PM
To: pgsql-perform
Subject: [PERFORM] Bad n_distinct estimation; hacks suggested?
[...]
(BTW, increasing the stats to 1000 only doubles n_distinct,
and doesn't solve the problem)
-Original Message-
From: Alex Turner [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 6:15 PM
To: Dave Held
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Intel SRCS16 SATA raid?
Looking at the numbers, the raptor with TCQ enabled was close or
beat the Atlas
-Original Message-
From: Alex Turner [mailto:[EMAIL PROTECTED]
Sent: Friday, April 15, 2005 9:44 AM
To: Marinos Yannikos
Cc: Joshua D. Drake; Mohan, Ross; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Intel SRCS16 SATA raid?
No offense to that review, but it was really
-Original Message-
From: Joel Fradkin [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 11:39 AM
To: 'Tom Lane'; 'Dawid Kuroczko'
Cc: 'PERFORM'
Subject: Re: [PERFORM] speed of querry?
I did as described to alter table and did not see any
difference in speed. I am trying
-Original Message-
From: Keith Worthington [mailto:[EMAIL PROTECTED]
Sent: Monday, April 11, 2005 7:44 PM
To: Neil Conway
Cc: PostgreSQL Perform
Subject: Re: [PERFORM] 4 way JOIN using aliases
Neil Conway wrote:
Keith Worthington wrote:
- Seq Scan on
-Original Message-
From: Keith Worthington [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 12, 2005 1:14 PM
To: Dave Held; PostgreSQL Perform
Subject: Re: [PERFORM] 4 way JOIN using aliases
I run vacuumdb with the analyze option every morning via a
cron job. In my ignorance I
-Original Message-
From: Arjen van der Meijden
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 06, 2005 11:53 AM
To: performance pgsql
Subject: [PERFORM] Plan for relatively simple query seems to be very
inefficient
[...]
SELECT COUNT(*) FROM
data_main AS dm,
postcodes AS p
I'm using a Postgres table as the data source for a JTable
in a Java app. As a first approximation, I'm implementing
AbstractTableModel.getValueAt() like so:
public Object getValueAt(int row, int col)
{
try
{
rs_.absolute(row + 1);
return
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 22, 2005 3:48 PM
To: Greg Stark
Cc: Christopher Browne; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] What about utility to calculate planner cost
constants?
[...]
The difficulty with the
-Original Message-
From: Dave Held
Sent: Tuesday, March 22, 2005 4:16 PM
To: Tom Lane
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] What about utility to calculate planner cost
constants?
[...]
Then instead of building a fixed cost model, why not evolve
-Original Message-
From: Greg Stark [mailto:[EMAIL PROTECTED]
Sent: Monday, March 07, 2005 5:15 PM
To: Dave Held
Cc: Greg Stark; John A Meinel; Tom Lane; Magnus Hagander; Ken
Egervari;
pgsql-performance@postgresql.org; [EMAIL PROTECTED]
Subject: Re: [pgsql-hackers-win32] [PERFORM
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, March 07, 2005 4:57 PM
To: John A Meinel
Cc: Dave Held; pgsql-performance@postgresql.org;
[EMAIL PROTECTED]
Subject: Re: [pgsql-hackers-win32] [PERFORM] Help with tuning
this query
(with
John A Meinel
I notice that by default, postgres sets numeric fields to
storage MAIN. What exactly does that mean? Does that mean
it stores it in some type of compressed BCD format? If so,
how much performance gain can I expect by setting the storage
to PLAIN? Also, the docs say that char(n) is implemented
-Original Message-
From: Jeremiah Jahn [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 03, 2005 2:15 PM
To: John A Meinel
Cc: postgres performance
Subject: Re: [PERFORM] name search query speed
[...]
So the count for this is generated on the fly needed for
pagination in the app
22 matches
Mail list logo
