On Mon, Dec 10, 2012 at 2:51 PM, Niels Kristian Schjødt
wrote:
> synchronous_commit = off
>
> The pg_xlog folder has been moved onto the SSD array (md3), and symlinked
> back into the postgres dir.
With synchronous_commit = off, or with large transactions, there is
probably no advantage to movin
On Dec 11, 2012, at 2:51 AM, Niels Kristian Schjødt
wrote:
> Pitch
> ##
> I previously posted this question
> http://archives.postgresql.org/pgsql-performance/2012-11/msg00289.php about a
> performance i
Pitch
##
I previously posted this question
http://archives.postgresql.org/pgsql-performance/2012-11/msg00289.php about a
performance issue with an update query.
The question evolved into a more general disc
> Greg's book is awesome. It really gives a lot of informations/tips/whatever
> on performances. I mostly remember all the informations about hardware, OS,
> PostgreSQL configuration, and such. Not much on the EXPLAIN part.
Arrived this morning :)
> http://www.pgcon.org/2010/audio/15%20The%20Po
classical_89 wrote:
> Hi everyone ,I have a question. I have a table with large data (i was used
> bytea datatype and insert a binary content to table ) so that Postgres help
> me get a TOAST table to storage out-of-line values .
> Assume that my table is " tbl_test " and toast table oid is 16816
