Kevin Grittner writes:
> Tom Lane wrote:
>> I wonder if we could ameliorate this problem by making
>> get_actual_variable_range() use SnapshotDirty
>> In that thread I claimed that a current MVCC snapshot was the
>> most appropriate thing, which it probably is;
> If it reads from the end of the
On Sun, Nov 10, 2013 at 4:40 PM, monalee_dba
wrote:
> Eg. SELECT col1, col2, col3,col10 FROM table1;
>
> For above query If I didn't mention ORDER BY clause, then I want to know
> selected data will appear in which order by a query planner?
The data will be selected in the order at which it is
http://www.postgresql.org/docs/9.3/static/using-explain.html
On Sun, Nov 10, 2013 at 4:32 PM, monalee_dba
wrote:
> I would like to know, What is BitMap Heap Scan & BitMap Index Scan? When I
> use EXPLAIN for query, which has LEFT JOIN with 4 different table then some
> time query planner uses Bit
Eg. SELECT col1, col2, col3,col10 FROM table1;
For above query If I didn't mention ORDER BY clause, then I want to know
selected data will appear in which order by a query planner?
Because I have huge size table, and when I applied ORDER BY col1, col2..in
query the
performance is soo bad that
Tom Lane wrote:
> I wonder if we could ameliorate this problem by making
> get_actual_variable_range() use SnapshotDirty
> In that thread I claimed that a current MVCC snapshot was the
> most appropriate thing, which it probably is;
If it reads from the end of the index, won't it actually be re
I would like to know, What is BitMap Heap Scan & BitMap Index Scan?When I use
EXPLAIN for query, which has LEFT JOIN with 4 different table thensome time
query planner uses Bitmap Heap Scan and some time Bitmap Index Scan?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com
On 11/12/13 6:17 PM, Jeff Janes wrote:
BTW, I originally had this, even after multiple queries:
Buffers: shared hit=1 read=9476
What were the timings like? Upon repeated execution it seems like all the buffers should be loaded
and so be "hit", not "read".
Well,
On Mon, Nov 11, 2013 at 4:30 PM, Jeff Janes wrote:
> On Mon, Nov 11, 2013 at 3:28 PM, Jim Nasby wrote:
>
>> On 11/11/13 4:57 PM, Jeff Janes wrote:
>>
>> On Mon, Nov 11, 2013 at 1:57 PM, Jim Nasby >> jna...@enova.com>> wrote:
>>> Btree indexes have special code that kill index-tuples when the
>>
Sergey i will try to monitor my pgsql activity for several days.
Scott about pooling connection. Yesterday i start read about spring
implementation of jdbc our app use dbcp implementation:
http://commons.apache.org/proper/commons-dbcp/configuration.html
So i have this parameter in config
