i.indisvalid,
>i.indcollation
> FROM pg_index i
> JOIN pg_class c ON i.indexrelid = c.oid
> WHERE i.indrelid IN (SELECT oid
>FROM pg_class
> WHERE relkind = 'r'
>
= 'data2013_01w'
> )
> ORDER BY 1;
>
>
> On Mon, Feb 1, 2016 at 5:51 PM, Yu Nie wrote:
>
>> Yeah, it is really puzzling. :(
>>
>> No, I have never attempted to cluster the large table - as I mentioned
>> before the
OR relname = 'data2013_01w'
> )
> ORDER BY 1;
>
>
> On Mon, Feb 1, 2016 at 5:51 PM, Yu Nie wrote:
>
>> Yeah, it is really puzzling. :(
>>
>> No, I have never attempted to cluster the large table
Galaxy S® 6, an AT&T 4G LTE smartphone
> Original message
> From: Yu Nie
> Date: 2/1/2016 15:17 (GMT-05:00)
> To: melvin6925
> Subject: Re: [GENERAL] strange sql behavior
>
> Yes, absolutely.
>
> On Mon, Feb 1, 2016 at 2:12 PM, melvin6925 wrote:
&g
l hours to create a table with 10 days of data from
the same month.
On Mon, Feb 1, 2016 at 2:21 PM, Adrian Klaver
wrote:
> On 02/01/2016 10:35 AM, Yu Nie wrote:
>
>> Hi there,
>>
>> Recently I am working with a large amount of taxis GIS data and had
>> encountered
45 PM, melvin6925 wrote:
> Thanks Bill.
> Also, it's very important to include the headers with the queries!
>
> Marco,
> There is no top secret information that is requested, so please do not
> edit the output.
>
>
>
> Sent via the Samsung Galaxy S® 6, an AT&
current_setting('autovacuum_vacuum_scale_factor')::numeric * C.reltuples)
> AS av_threshold
> FROM pg_stat_all_tables s
> JOIN pg_class c ON c.oid = s.relid
> JOIN pg_namespace n ON (n.oid = c.relnamespace)
> WHERE s.relname NOT LIKE 'pg_%'
>
Hi there,
Recently I am working with a large amount of taxis GIS data and had
encountered some weird performance issues. I am hoping someone in this
community can help me figure it out.
The taxi data were loaded in 5 minute block into a table. I have two
separate such tables, one stores a month
