On Mon, 28 Oct 2013 15:50:42 -0400 Robert James wrote:
> It could be > 1 Million rows.
>
> SELECT is:
>
> SELECT *
> FROM another_table
> WHERE
> eventtime > (SELECT e FROM tags WHERE id = $1) AND
> eventtime < (SELECT e FROM tags WHERE id = $2)
> ;
>
>
On 10/28/2013 12:50 PM, Robert James wrote:
It could be > 1 Million rows.
Well that would be a reason.
SELECT is:
SELECT *
FROM another_table
WHERE
eventtime > (SELECT e FROM tags WHERE id = $1) AND
eventtime < (SELECT e FROM tags WHERE id = $
It could be > 1 Million rows.
SELECT is:
SELECT *
FROM another_table
WHERE
eventtime > (SELECT e FROM tags WHERE id = $1) AND
eventtime < (SELECT e FROM tags WHERE id = $2)
;
$1 and $2 are integers.
SELECT ran just now, returning >1Million rows, i
2013/10/27 Robert James
> On 10/27/13, Thomas Kellerer wrote:
> > Robert James wrote on 27.10.2013 20:47:
> >> I'm using Postgres for data analysis (interactive and batch). I need
> >> to focus the analysis on a subset of one table, and, for both
> >> performance and simplicity, have a function
On 10/27/2013 02:48 PM, Robert James wrote:
On 10/27/13, Adrian Klaver wrote:
Is there another problem here? Perhaps something to do with
triggerring autovacuum?
Is there a FK relationship involved?
Could we see the schema for another_table?
1. No FK
2. I removed the indexes from the t
On 10/27/13, Adrian Klaver wrote:
> On 10/27/2013 02:23 PM, Robert James wrote:
>> On 10/27/13, Thomas Kellerer wrote:
>>> Robert James wrote on 27.10.2013 20:47:
I'm using Postgres for data analysis (interactive and batch). I need
to focus the analysis on a subset of one table, and, f
On 10/27/2013 02:23 PM, Robert James wrote:
On 10/27/13, Thomas Kellerer wrote:
Robert James wrote on 27.10.2013 20:47:
I'm using Postgres for data analysis (interactive and batch). I need
to focus the analysis on a subset of one table, and, for both
performance and simplicity, have a functio
On 10/27/13, Thomas Kellerer wrote:
> Robert James wrote on 27.10.2013 20:47:
>> I'm using Postgres for data analysis (interactive and batch). I need
>> to focus the analysis on a subset of one table, and, for both
>> performance and simplicity, have a function which loads that subset
>> into ano
Robert James wrote on 27.10.2013 20:47:
I'm using Postgres for data analysis (interactive and batch). I need
to focus the analysis on a subset of one table, and, for both
performance and simplicity, have a function which loads that subset
into another table (DELETE FROM another_table; INSERT INT
I'm using Postgres for data analysis (interactive and batch). I need
to focus the analysis on a subset of one table, and, for both
performance and simplicity, have a function which loads that subset
into another table (DELETE FROM another_table; INSERT INTO
another_table SELECT ...).
Oddly enough
10 matches
Mail list logo
