Hi all -
I've got a schema I'm working on modifying, nad I need some help getting
the best performance out. The orginal schema has a many to many linkage
between a couple tables, using a two column linkage table. This is used
to represent groups of people and their relationship to an object
On Mon, Jul 26, 2004 at 02:27:20AM -0400, Greg Stark wrote:
Ross J. Reedstrom [EMAIL PROTECTED] writes:
In the new schema, the same thing is:
SELECT * from content where 42 = ANY (authors);
Works fine, but for the life of me I can't find nor figure out how to
build an index
Recently I've been working on improving the performance of a system that
delivers files stored in postgresql as bytea data. I was surprised at
just how much a penalty I find moving from a domain socket connection to
a TCP connection, even localhost. For one particular 40MB file (nothing
outragous)
On Tue, Feb 17, 2009 at 12:20:02AM -0700, Rusty Conover wrote:
Try running tests with ttcp to eliminate any PostgreSQL overhead and
find out the real bandwidth between the two machines. If its results
are also slow, you know the problem is TCP related and not PostgreSQL
related.
I
On Tue, Feb 17, 2009 at 01:59:55PM -0700, Rusty Conover wrote:
On Feb 17, 2009, at 1:04 PM, Ross J. Reedstrom wrote:
What is the client software you're using? libpq?
python w/ psycopg (or psycopg2), which wraps libpq. Same results w/
either version.
I think I'll try network sniffing
On Tue, Feb 17, 2009 at 03:14:55PM -0600, Ross J. Reedstrom wrote:
On Tue, Feb 17, 2009 at 01:59:55PM -0700, Rusty Conover wrote:
What is the client software you're using? libpq?
python w/ psycopg (or psycopg2), which wraps libpq. Same results w/
either version.
It's not python
[note: sending a message that's been sitting in 'drafts' since last week]
Summary: C client and large-object API python both send bits in
reasonable time, but I suspect there's still room for improvement in
libpq over TCP: I'm suspicious of the 6x difference. Detailed analysis
will probably find
On Thu, Feb 19, 2009 at 02:09:04PM +0100, PFC wrote:
python w/ psycopg (or psycopg2), which wraps libpq. Same results w/
either version.
I've seen psycopg2 saturate a 100 Mbps ethernet connection (direct
connection with crossover cable) between postgres server and client during
Excellent. I'll take a look at this and report back here.
Ross
On Mon, Feb 23, 2009 at 04:17:00PM -0500, Tom Lane wrote:
Ross J. Reedstrom reeds...@rice.edu writes:
Summary: C client and large-object API python both send bits in
reasonable time, but I suspect there's still room
On Sat, Mar 20, 2010 at 10:47:30PM -0500, Andy Colson wrote:
I guess, for me, once I started using PG and learned enough about it (all
db have their own quirks and dark corners) I was in love. It wasnt
important which db was fastest at xyz, it was which tool do I know, and
trust, that
On Tue, Mar 23, 2010 at 03:22:01PM -0400, Tom Lane wrote:
Ross J. Reedstrom reeds...@rice.edu writes:
Andy, you are so me! I have the exact same one-and-only-one mission
critical mysql DB, but the gatekeeper is my wife. And experience with
that instance has made me love and trust
On Sun, Jan 30, 2011 at 05:18:15PM -0500, Tom Lane wrote:
Andres Freund and...@anarazel.de writes:
What happens if you change the
left join event.origin on event.id = origin.eventid
into
join event.origin on event.id = origin.eventid
?
The EXISTS() requires that origin is
On Thu, Feb 03, 2011 at 12:44:23PM -0500, Chris Browne wrote:
mladen.gog...@vmsinfo.com (Mladen Gogala) writes:
Hints are not even that complicated to program. The SQL parser should
compile the list of hints into a table and optimizer should check
whether any of the applicable access
On Tue, Feb 08, 2011 at 03:52:31PM -0600, Kevin Grittner wrote:
Scott Marlowe scott.marl...@gmail.com wrote:
Greg Smith g...@2ndquadrant.com wrote:
Kevin and I both suggested a fast plus timeout then immediate
behavior is what many users seem to want.
Are there any settings in
14 matches
Mail list logo