Fellow PostgreSQLers,
With a bit of guidance from Klint Gore, Neil Conway, Josh Berkus, and
Alexey Dvoychenkov, I have written a PL/pgSQL function to help me
compare the performance between different functions that execute the
same task. I've blogged the about the function here:
http://
Where can I find any documentation to partition the tablespace disk files onto
different physical arrays for improved performance?
-Kenji
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/d
(Its been a hour and I dont see my message on the
list so I'm sending it again. I've moved the queries and analyze out of the
email incase it was rejected because too long)
query: http://pastebin.ca/57218
In the pictures table all the ratings have a shared index
CREATE INDEX idx_rating O
On Thu, May 18, 2006 at 12:38:18PM -0700, Stephen Byers wrote:
> I repeated explain analyze on the query 5 times and it came up with the same
> plan.
>
> You asked about index order and physical table order. In general the index
> order is indeed close to the same order as the physical table
On Thu, May 18, 2006 at 11:20:17AM -0400, Chris Mckenzie wrote:
> Yes, regular versus full vacuum. Thanks for the comment but I was hoping to
> come to that conclusion on my own by observing the affects of the different
> vacuums.
>
> My original question was guidance on collecting data for confir
On Thu, May 18, 2006 at 12:48:42PM +0200, Jean-Paul Argudo wrote:
> > autovaccuum = on
>
> Thats a critic point. Personaly I dont use autovacuum. Because I just
> don't want a vacuum to be started ... when the server is loaded :)
>
> I prefer control vacuum process, when its possible (if its not,
On Thu, May 18, 2006 at 02:44:40PM +0200, Chris Mair wrote:
> Yes, pg_xlog ist also used with fsync=off. you might gain quite some
> performance if you can manage to put pg_xlog on its own disk (just
> symlink the directory).
Substantially increasing wal buffers might help too.
--
Jim C. Nasby,
"Olivier Andreotti" <[EMAIL PROTECTED]> writes:
> Just a last question about the pg_xlog : i understand that the
> directory must be moved but i have just 3 disks for the database :
> disk 1 and 2 for the data, disk 3 for the indexes, where can i put the
> pg_xlog ?
If you have three disks then pu
Hello everybody !
Thanks for all the advices, iI will try all theses new values, and
i'll post my final values on this thread.
About the benchmark and the results, i dont know if can publish values
about Oracle performance ? For MySQL and PostgreSQL, i think there is
no problems.
Just a last qu
