On Tue, Mar 23, 2010 at 12:12 AM, Greg Smith g...@2ndquadrant.com wrote:
Carlo Stonebanks wrote:
So, we have the hardware, we have the O/S - but I think our config leaves
much to be desired. Typically, our planner makes nad decisions, picking seq
scan over index scan, where index scan has a
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
Ross J. Reedstrom reeds...@rice.edu writes:
On Sat, Mar 20, 2010 at 10:47:30PM -0500, Andy Colson wrote:
(I added the and trust as an after thought, because I do have one very
important 100% uptime required mysql database that is running. Its my
MythTV box at home, and I have to ask
On Tue, Mar 23, 2010 at 1:22 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Ross J. Reedstrom reeds...@rice.edu writes:
On Sat, Mar 20, 2010 at 10:47:30PM -0500, Andy Colson wrote:
(I added the and trust as an after thought, because I do have one very
important 100% uptime required mysql database that
I would greatly appreciate any advice anyone could give me in terms of
performance tuning a large PL/PGSQL stored procedure. First, I should point
out that I have read a considerable amount of information in the online
PostgreSQL documentation and on Google about optimizing SQL queries and
Tom Lane wrote:
So has anyone looked at porting MythTV to PG?
Periodically someone hacks together something that works, last big
effort I'm aware of was in 2006, and then it bit rots away. I'm sure
we'd get some user uptake on the result--MySQL corruption is one of the
top ten cause of
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 Tue, Mar 23, 2010 at 2:54 PM, Bhella Paramjeet-PFCW67
pbhe...@motorola.com wrote:
Hi All,
We have a postgres database in which couple of tables get bloated due to
heavy inserts and deletes. Auto vacuum is running. My question is how can I
make auto vacuum more aggressive? I am thinking
What about InnoDB?
On Tue, Mar 23, 2010 at 4:38 PM, Greg Smith g...@2ndquadrant.com wrote:
Tom Lane wrote:
So has anyone looked at porting MythTV to PG?
Periodically someone hacks together something that works, last big effort
I'm aware of was in 2006, and then it bit rots away. I'm
On Tue, Mar 23, 2010 at 5:07 PM, Dave Crooke dcro...@gmail.com wrote:
What about InnoDB?
Depends on what parts of mysql they otherwise use. There are plenty
of features that won't work if you're using non-myisam tables, like
full text search. I tend to think any full blown (or nearly so) db is
Scott Marlowe scott.marl...@gmail.com writes:
On Tue, Mar 23, 2010 at 5:07 PM, Dave Crooke dcro...@gmail.com wrote:
What about InnoDB?
Depends on what parts of mysql they otherwise use. There are plenty
of features that won't work if you're using non-myisam tables, like
full text search. I
MyISAM is SQLLite with some threading ;-)
On Tue, Mar 23, 2010 at 6:30 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Tue, Mar 23, 2010 at 5:07 PM, Dave Crooke dcro...@gmail.com wrote:
What about InnoDB?
Depends on what parts of mysql they otherwise use. There are plenty
of features
On Tue, Mar 23, 2010 at 5:35 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Scott Marlowe scott.marl...@gmail.com writes:
On Tue, Mar 23, 2010 at 5:07 PM, Dave Crooke dcro...@gmail.com wrote:
What about InnoDB?
Depends on what parts of mysql they otherwise use. There are plenty
of features that
13 matches
Mail list logo