Hi,
Our usage of postgres is bit unconventional. It is used for passing
data between programs (in real time).
First program, lets say the writer, (using psql) appends to a table
in the database.
Second program, the reader, (python using alchemy) reads the data.
This happens in loop, one for
, 2016 at 11:43 AM, Tom Lane wrote:
> Sandeep Gupta writes:
>> First program, lets say the writer, (using psql) appends to a table
>> in the database.
>> Second program, the reader, (python using alchemy) reads the data.
>> This happens in loop, one for each day.The
= 23321
Although the planner picks the second one. What it is about the query
planner
that make it skip plans using the index on pid?.
Thanks.
Sandeep
On Sun, May 18, 2014 at 9:43 PM, Sandeep Gupta
wrote:
> Hi,
>
> I have typical setup consisting of two tables (demograph
On a table T with two fields, f1 and f2, the sql command
select count(f2), f1
from T
group by f1
result is seq scan followed by a sort on f1 (see the query plan below):
GroupAggregate (cost=21566127.88..22326004.09 rows=987621 width=8)
-> Sort (cost=21566127.88..21816127.88 rows=10
I have two postgres instances each with a database of same schema. The
dataset in both is ''same'' but for randomness i.e. both contain two
tables pc(did) and tc(pid, did) that have almost
same number of rows and have been generate from same distribution.
However the query plan for the join turn
t;
> Regards
>
> Pavel
>
> 2013/7/31 Sandeep Gupta :
> > I have two postgres instances each with a database of same schema. The
> > dataset in both is ''same'' but for randomness i.e. both contain two
> tables
> > pc(did) and tc(pid, did) that
p Fetches: 1000834
Buffers: shared hit=2235972 read=204867
Total runtime: 2386.914 ms
(12 rows)
On Wed, Jul 31, 2013 at 3:16 PM, Sandeep Gupta wrote:
> Hi Pavel,
>
> Yes. The postgresql.conf is exactly the same. The have the same index
> and clustering and are on the same compu
@Jeff : Thanks for pointing this out. Turns out that was the case.
@Tom: Thank you for the reference to random_page_cost parameters. It would
be very useful for us. Would go through the rest of the documentation as
well.
On Wed, Jul 31, 2013 at 3:55 PM, Tom Lane wrote:
> Sandeep Gupta wri
Currently, the postgres database by has SQL_ASCII encoding.
psql -p 5771 postgres -l
List of databases
Name| Owner | Encoding | Collate | Ctype | Access privileges
---+-+---+-+---+-
postgres | sandeep
Thank you.
On Wed, May 10, 2017 at 12:54 PM, Adrian Klaver
wrote:
> On 05/10/2017 08:48 AM, Sandeep Gupta wrote:
>>
>> Currently, the postgres database by has SQL_ASCII encoding.
>>
>> psql -p 5771 postgres -l
>> List of databases
&
I have set max_connection = 40.
The usage is somewhat not typical. It is basically
experiment runs that connect to the database
and dump results there.
The experiments connect through JDBC and
they close the connection when they are done.
I can verify that no more than 20 clients/experiments
are
The log_connections helped. I was able
to diagnose the problem. The connections
are getting closed but my setup is actually generating
too many connections.
Thanks for helping with this.
-sandeep
On Tue, May 16, 2017 at 6:53 PM, Tom Lane wrote:
> Sandeep Gupta writes:
>> I
I install postgres 9.6.5 on CentOS 6.8.
However, i am not able to init the database due to the following error.
A bug
(http://www.postgresql-archive.org/BUG-8139-initdb-Misleading-error-message-when-current-user-not-in-etc-passwd-td5754618.html)
was reported with similar problem with but that was
Hello,
I am on Cent OS 6.8 machine. The Postgres is already installed in some
install_dir/.
I downloaded the source, configured it with prefix=install_dir and
then moved to contrib/postgres_fdw dir.
However make fails with following error:
gcc -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclarat
Hi,
I compiled g postgres9.3beta2 with PL/R which works fine. However, when I
execute the command create extension plr, I get following error:
ERROR: could not load library
"/apps/packages/postgresql/9.3beta2/lib/plr.so":
/apps/packages/postgresql/9.3beta2/lib/plr.so: undefined symbol:
HeapTupl
Hi,
My postgres sessions, after being idle for 5 --6 hrs, crash on their own.
Sometimes with error messages sometimes without. The message I get appended
below. I was looking for suggestion to narrow down as to what could have
caused this problem. System log doesn't show anything.
Thanks.
Sandee
net which tell how to fix this problem. But
first would be good to confirm that it is OOM and, if not, then what
exactly is causing this to happen.
-Sandeep
On Sat, Nov 9, 2013 at 10:46 AM, Scott Marlowe wrote:
> On Fri, Nov 8, 2013 at 8:16 PM, Sandeep Gupta
> wrote:
> > Hi,
Agreed. However, the "tuple not found" error problem seems to happen with
postgres as well, if not in the particular case index creation over large
datasets. It would helpful to know in that scenario what are the fixes and
how to avoid it in the first place.
The solution/fixes for postgres will ca
iate any pointers on this.
-Sandeep
On Mon, Dec 9, 2013 at 1:43 PM, Sandeep Gupta wrote:
> Agreed. However, the "tuple not found" error problem seems to happen with
> postgres as well, if not in the particular case index creation over large
> datasets. It would helpful to know
at 5:49 PM, Michael Paquier
wrote:
> On Tue, Dec 10, 2013 at 7:17 AM, Sandeep Gupta
> wrote:
> > We are trying to trace cause and potential solution of "tuple not found"
> > error with postgres-xc. The problem happens when indexing a large file.
> It
> > see
>
> On Tue, Dec 10, 2013 at 11:23 PM, Michael Paquier <
> michael.paqu...@gmail.com> wrote:
>
>> On Wed, Dec 11, 2013 at 1:17 PM, Sandeep Gupta
>> wrote:
>> > Hi Michael,
>> >
>> > I can provide the table schema and the data over whi
Hi,
I looked for description of sublinks in the code as well as online but
failed to come with any information. Was wondering someone can provide a
line or two of what sublinks are suppose to do?
Thanks.
Sandeep
Hi Tom,
Sure. Thanks for the info. This helps. I will look into primnodes.h as
well.
-Sandeep
On Fri, Mar 28, 2014 at 3:56 PM, Tom Lane wrote:
> Sandeep Gupta writes:
> > I looked for description of sublinks in the code as well as online but
> > failed to come with
Hi,
I have typical setup consisting of two tables (demography and ses) with a
typical filter-join-groupby-orderby query.
Schemas:
demography (pid int, countyid int)
ses (pid int, exposed_time int)
query:
select countyid, count(pid)
from demography, ses
where demography.pid = ses.pid
and expose
24 matches
Mail list logo
