Can somebody explain what does the postgres done for the explain of sql shows
HashAggregate( what is the meaning for HashAggregate )?
for example:
postgres=# explain verbose select oid,relname from pg_class group by
oid,relname;
QUERY PLAN
Hi all,
I change the value of "unix_socket_directories" in postgresql.conf , then
restart the database, but it cannot connect the database used like this
"psql -d postgres -p 5432" , it must given the parameter " -h /xx/xx" to use
the Unix domain socket。
how to fix this issue ?
th
Hi all,
When using the command "pg_dump -Fd" to backup data, I find the content of
toc.dat is hard for read, just like this:
" ^@"^@^@^@DROP SEQUENCE public.test_id_seq" , So may be we should do some work
to make the file "toc.dat" more readable.
Thanks,
Lin
Hi,all:
I create a schema (sch1) in the database of db1, and I also create a
table sch1.t1, then I use the comand "pg_dump -d db1 -Fd -f dir1" to back up
the database of db1; at lase I drop the schema of sch1; I want to restore
the schema sch1, but when I execute the command "pg_restor
Are you sure it is a bug and you have fixed it? I test it with
postgresql-9.4rcl, the result is the same with postgresql-9.3 beta2.
At 2014-12-09 23:54:01, "Tom Lane" wrote:
>lin writes:
>> I create a schema (sch1) in the database of db1, and I also create
Hi,
everyone. I am puzzled about the question: the master A has two slave
slave_1 , slave_2 , the version of postgres is 9.3. I want to promote one slave
to master, and the other slave as the new master's slave, but which slave
should can promote ?
get the master-slave information from old
Hi,
all. I use "pg_basebackup" to make slave, but the master has too large logs
of pg_log, How Can I use "pg_basebackup" but not include logs of "pg_log" ?
best regards,
wln
e->d_name, "..") == 0)
++ if (strcmp(de->d_name, ".") == 0 || strcmp(de->d_name, "..") == 0 ||
strcmp(de->d_name, "pg_log"))
Is there something wrong ?
Thanks,
wln
At 2017-03-20 20:43:11, "Michael Paquier" wr
Hi,
all. I have test the function "internal_ping", and find in some conditions,
the return result is not right.
the code, you can see :
http://code.taobao.org/p/pgsql953/src/src/interfaces/libpq/fe-connect.c
if conn->status == CONNECTION_BAD , and the "conn->last_sqlstate" is
"28000", th
Hi,
all. I use "AEXPR_OR", "AEXPR_AND" in postgres 9.3 ,now I update the
postgres version to 9.6, but the 9.6 version has not the "AEXPR_OR",
"AEXPR_AND".
How can I solve the problem ?
Thanks,
wln
Hi all,
I am puzzled for how to use the struct "RangeFunction" in Postgres 9.6, the
struct "RangeFunction" is not the same with 9.3.
Can someone help me how to write the function "make_RangeFunction"?
the code as below:
SelectStmt *stmt = makeNode(SelectStmt);
List *args = list
Hi,
Version 9.4...
Per the PG docs, to facilitate continuous WAL archiving and PITR recovery...
"To enable WAL archiving, set the wal_level configuration parameter to archive
(or hot_standby), archive_mode to on, and specify the shell command to use in
the archive_command configuration paramet
Thanks very much for your reply Michael.
I note that it looks like pgbarman employs pg_receivexlog; I will check it out.
Regards,
Ruan
From: Michael Paquier
Sent: 22 October 2017 22:17:01
To: Rhhh Lin
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL
ng called upon again for restartpoints/checkpoints.
That is, where is my absolute point (or file) of archival using something along
the lines of 'pg_current_xlog_location'.
Regards,
Ruan
From: Stephen Frost
Sent: 30 October 2017 16:41:11
Hi all,
version = Postgres 9.3.10
I have a table with approx. 5 million rows. It is defined something like the
below.
col: type:
timestamp bigint
measurement_id integer
value numeric(24,5)
minval numeric(24,5)
maxval numeric(24,5)
There are two BTree indexes in place on the PK ("timestamp", "me
: Justin Pryzby
Sent: 02 November 2017 21:02
To: Rhhh Lin
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] EXPLAIN command just hangs...
On Thu, Nov 02, 2017 at 08:51:23PM +, Rhhh Lin wrote:
> However, this query will run for days without completing. I suspect it has to
> do w
ot;timestamp", but right now I cannot
check and verify because it just hangs...
Regard,
Ruan
From: Tom Lane
Sent: 02 November 2017 21:40
To: Rhhh Lin
Cc: Justin Pryzby; pgsql-general@postgresql.org
Subject: Re: [GENERAL] EXPLAIN command just hangs.
y repercussions...
Regards,
Ruan
From: Justin Pryzby
Sent: 02 November 2017 21:49
To: Rhhh Lin
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] EXPLAIN command just hangs...
On Thu, Nov 02, 2017 at 09:13:05PM +, Rhhh Lin wrote:
> Yes, it may be an issue with the index, but I&
art the server, implement a vacuum
execution and see where I am at then.
Regards,
Ruan
From: Justin Pryzby
Sent: 03 November 2017 21:33
To: Rhhh Lin
Cc: Tom Lane; pgsql-general@postgresql.org
Subject: Re: [GENERAL] EXPLAIN command just hangs...
On Fri, Nov 03,
Thanks for the explanation Kevin!
Regards,
Ruan
From: pgsql-general-ow...@postgresql.org
on behalf of K. Brannen
Sent: 03 November 2017 14:35
To: pgsql-general@postgresql.org
Subject: [GENERAL]
Rhhh Lin wrote:
> *Also, as a sidenote - can someone ple
, Rhhh Lin wrote:
[...]
> where timestamp BETWEEN 150667656 AND 150875022
[...]
> *Also, as a sidenote - can someone please expand on why one (I was not
> involved
> in the creation of this DB/schema definition) would choose to have the
> definition of the timestamp column as a
site willy.
java.sql.SQLException: User authentication failed
If I tried local database url="repl_willy", the same username and password
work well.
I did run "createuser" script and even run SQL "create user ..".
What do I missed?
Thanks,
Yi Lin
Hi !
I am new comer to PostgreSQL. I have few years experience of OODB
(CA-Jasmine). It's is possible to give PostgreSQL more oo support in future release ?
If PostgreSQL can support method and collection will very helpful.
I hope the mail-list was the correctly place to post
23 matches
Mail list logo
