On Thu, Mar 3, 2011 at 8:26 AM, Robert Haas wrote:
> On Thu, Mar 3, 2011 at 9:13 AM, Matt Burke wrote:
>> Hi. I've only been using PostgreSQL properly for a week or so, so I
>> apologise if this has been covered numerous times, however Google is
>> producing nothing of use.
>>
>> I'm trying to im
On 3/3/2011 3:19 AM, sverhagen wrote:
Andy Colson wrote:
For your query, I think a join would be the best bet, can we see its
explain analyze?
Here is a few variations:
SELECT events_events.* FROM events_events WHERE transactionid IN (
SELECT transactionid FROM events_eventdetail
On Thu, Mar 3, 2011 at 9:13 AM, Matt Burke wrote:
> Hi. I've only been using PostgreSQL properly for a week or so, so I
> apologise if this has been covered numerous times, however Google is
> producing nothing of use.
>
> I'm trying to import a large amount of legacy data (billions of
> denormali
Hi. I've only been using PostgreSQL properly for a week or so, so I
apologise if this has been covered numerous times, however Google is
producing nothing of use.
I'm trying to import a large amount of legacy data (billions of
denormalised rows) into a pg database with a completely different schem
Andy Colson wrote:
>
> For your query, I think a join would be the best bet, can we see its
> explain analyze?
>
Here is a few variations:
SELECT events_events.* FROM events_events WHERE transactionid IN (
SELECT transactionid FROM events_eventdetails customerDetails
WHERE cu
do you have any indexes on that table ?
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
On 2-3-2011 16:29 Robert Haas wrote:
On Mon, Feb 28, 2011 at 2:09 PM, Josh Berkus wrote:
Does anyone have the hardware to test FlashCache with PostgreSQL?
http://perspectives.mvdirona.com/2010/04/29/FacebookFlashcache.aspx
I'd be interested to hear how it performs ...
It'd be a lot more int
