[GENERAL] Set cost for a specific index scan

Hi all, I'm using an open-source "extension" that creates an index for special type of search and you need to use a custom operator to run queries. Anyway If I run an according query with multiple filters as example also range of primary key PostgreSQL almost always selects this 3rd party ind

[GENERAL] Installing an Extension

Hi all, how can I install/use an extension form pgfoundry, namely this one: http://pgfoundry.org/projects/pgchem/ it does not come with any kind of installation instructions. (note: for windows) Best Regards, Thomas

Re: [GENERAL] Recommendations for SSDs in production?

Vertex 3 and ocz in general has a very bad reputation in the "enthusiast scene". Sudden issues, hard locks, data loss and so on. Just go and look in the OCZ forums. I would not dare by on Vertex 3 for my desktop...have 2 Intel ones. I have no idea what you do but just the fact that you bough