×

Announcing: Slashdot Deals - Explore geek apps, games, gadgets and more. (what is this?)

Thank you!

We are sorry to see you leave - Beta is different and we value the time you took to try it out. Before you decide to go, please take a look at some value-adds for Beta and learn more about it. Thank you for reading Slashdot, and for making the site better!

Comments

top

PostgreSQL Slammed by PHP Creator

jabbo Re:Postgres (527 comments)

> I spoke to the developers and was told in a rather snooty reply that they had no plans to allow the user to optionally disable transactional 'features'.

If you don't need transactions, why are you bothering with a database? Just use a coherent shared-memory cache and dispense with the slowdown from parsing queries.

It's called a design decision, and the postgres developers decided to focus on features important to people who need transactions. If you really want this 'feature' (non-transactional behavior), and it can't be set as one of the transaction isolation levels, I'm sure they'd be willing to accept a patch from you.

Or use Postgres' autovacuum features. You aren't, by chance, referring to an ancient version of Postgres that lacked autovacuum, are you? I was under the impression (having used Postgres in some fairly heavy-duty deployments with thousands of concurrent users) that this is exactly what VACUUM takes care of. Autovacuum must be even nicer. I wouldn't know, I seem to use MySQL all the time nowadays unless the task requires a real database.

Or, hell, you could (gasp) use MySQL. Its original design was focused on non-transactional database needs. It's great for light-duty things where you want to throw them together and not spend too long optimizing queries.

Use the right tool for the job... maybe postgres isn't the right tool for your jobs.

That's not really something you can attribute to the tool manufacturers, you know?

more than 8 years ago

Submissions

jabbo hasn't submitted any stories.

Journals

jabbo has no journal entries.

Slashdot Login

Need an Account?

Forgot your password?