On Tue, Mar 23, 2010 at 5:35 PM, Tom Lane wrote:
> Scott Marlowe writes:
>> On Tue, Mar 23, 2010 at 5:07 PM, Dave Crooke 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
MyISAM is SQLLite with some threading ;-)
On Tue, Mar 23, 2010 at 6:30 PM, Scott Marlowe wrote:
> On Tue, Mar 23, 2010 at 5:07 PM, Dave Crooke 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-
Scott Marlowe writes:
> On Tue, Mar 23, 2010 at 5:07 PM, Dave Crooke 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 n
On Tue, Mar 23, 2010 at 5:07 PM, Dave Crooke 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
overkill for myt
What about InnoDB?
On Tue, Mar 23, 2010 at 4:38 PM, Greg Smith 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 sure we'd get
On Tue, Mar 23, 2010 at 2:54 PM, Bhella Paramjeet-PFCW67
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 of enabling
>
On Tue, Mar 23, 2010 at 03:22:01PM -0400, Tom Lane wrote:
> "Ross J. Reedstrom" 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 PostgreSQL even
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 a
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
PostgreS
On Tue, Mar 23, 2010 at 1:22 PM, Tom Lane wrote:
> "Ross J. Reedstrom" 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
>>
"Ross J. Reedstrom" 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 permission fro
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, tha
On Tue, Mar 23, 2010 at 12:12 AM, Greg Smith 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 better result
13 matches
Mail list logo
