lse, esp. if it's low hanging fruit, w00t.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
at's what I got from the thread, anyway.
I'm interested to know how similar performance might be between the large
block size case and the large readahead case. Comments, anyone?
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
it would be convenient to avoid having to query
$external_pooler to determine the client_addr of an incoming connection.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
systems is generally from 64MB to 512MB." [1]
[1] http://www.postgresql.org/docs/8.4/static/runtime-config-resource.html
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
e suggested. ("Re(?)plan parameterized plans with actual parameter
values" on http://wiki.postgresql.org/wiki/PgCon_2010_Developer_Meeting,
specificall). This wouldn't show up until at least 9.1, but it's something
people are thinking about.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
7.3.7, and no amount of
hardware tuning will make such an old version perform comparatively well. Not
to mention the much greater risk you have that an unsupported version will eat
your data.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
#x27;s
easy to create identically on your destination database:
pg_dump -s -t baz > baz.schema
Having recreated the table on the destination database, using COPY to restore
the selected data is straightforward:
COPY baz FROM 'some_file';
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
formation, use your operating system.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
e.
'' means that the client has opened a transaction but
isn't doing anything right now. If you issue a "BEGIN;" command and then just
sit there, for instance, you'll see these.
'END' is synonymous with 'COMMIT', so where those show up, it means the
On Tue, Jun 16, 2009 at 03:37:42PM +0200, Alberto Dalmaso wrote:
> Hi everybody, I'm creating my database on postgres and after some days
> of hard work I'm arrived to obtain good performance and owfull
> performace with the same configuration.
> I have complex query that perform very well with mer
On Fri, Jun 12, 2009 at 04:40:12PM -0400, Alan McKay wrote:
> Any pointers for good reading material here? Other tips?
The manuals and/or source code for your software? Stories, case studies, and
reports from others in similar situations who have gone through problems?
Monitoring's job is to ave
On Fri, Jun 12, 2009 at 03:52:19PM -0400, Alan McKay wrote:
> I want to turn off the graphing of unimportant data, to unclutter the
> graphs and focus on what's important.
I'm unfamiliar with Munin, but if you can turn off the graphing (so as to
achieve your desired level of un-cluttered-ness) wit
On Wed, Nov 12, 2008 at 02:22:47PM +0100, Julien Theulier wrote:
> QUESTION: Why the planner choose seq scan in the first case & indexes scan
> in the second case? In a more general way, I observed that the planner has
> difficulties to select index scans & does in almost all the cases seq scan,
>
13 matches
Mail list logo
