On 11/01/13 03:23, Kevin Grittner wrote:
Sergey Konoplev wrote:
As far as I know, the application programs do not make any
specific lock on the 'file' table. I'm not sure if it is caused
by the pgpool or something else.
[...]
2013-10-31 18:01:30 UTCLOG: sending cancel to blocking autovacu
Hello,
I'm running an application (with programs in Perl) through pgpool 3.1
with replication mode to two postgresql db servers (version 9.0.13).
Recently, I noticed that the following messages repeatedly showed in
postgres log files. As far as I know, the application programs do not
make a
On 02/28/11 19:30, Andres Freund wrote:
Hi,
On Wednesday 23 February 2011 19:31:58 Gary Fu wrote:
I'm testing on converting a big Sybase db to Pg. It took about 45 hours
to convert all sybase tables (bcp) to Pg (copy) without index and
reference. After that I built the index (one b
On 02/28/11 17:56, Andres Freund wrote:
Hi,
On Saturday, February 26, 2011 12:11:19 AM Gary Fu wrote:
wal_buffers = 16MB
sensible
checkpoint_segments = 256
A setting that high seems unlikely to be beneficial... I suggest you configure
log_checkpoints to monitor this.
effective_cache_size
On 02/28/11 17:32, Andy Colson wrote:
Here are the more test results on the 3rd ref and parallel on 2nd and
3rd references:
325 mins on FK_FM_ALL_REF_FILE (334 mins previous)
parallel results on 2nd and 3rd references: (much worse on 2nd ref)
Here are some information on my system:
1:
On 02/25/11 18:11, Gary Fu wrote:
On 02/25/11 17:22, Andy Colson wrote:
On 2/23/2011 12:31 PM, Gary Fu wrote:
Hi,
I'm testing on converting a big Sybase db to Pg. It took about 45 hours
to convert all sybase tables (bcp) to Pg (copy) without index and
reference. After that I built the
On 02/25/11 17:22, Andy Colson wrote:
On 2/23/2011 12:31 PM, Gary Fu wrote:
Hi,
I'm testing on converting a big Sybase db to Pg. It took about 45 hours
to convert all sybase tables (bcp) to Pg (copy) without index and
reference. After that I built the index (one by one, sequentially) a
Hi,
I'm testing on converting a big Sybase db to Pg. It took about 45 hours
to convert all sybase tables (bcp) to Pg (copy) without index and
reference. After that I built the index (one by one, sequentially) and
it took about 25 hours and then I started to add the references (one by
one),
Hi,
Why do I get the message in Subject when I do 'select proc_sub_b()'
under psql ? If I comment out the RAISE statement in proc_sub_a then I
don't see the message.
Thanks,
Gary
int_admin.modaps_int> select proc_sub_b();
INFO: id=11
CONTEXT: PL/pgSQL function "proc_sub_b" line 7 at assig
art of your content).
You can obviously insert 2 consecutive single quotes within a single
double-quoted string - or any characters... just be aware you are in
double-quotes now, so you need to escape special characters or go back
to single quotes.
Your example:
psql -c ' Copy "Table" f
Hi,
How do I escape both " and ' to be used in the 'psql -c ' command ?
For example, how to make the psql command {\copy "Table" from
'txt_file'} to be used in the psql with -c option (psql -c) ?
The "Table" has to be double quoted here.
Thanks,
Gary
--
Sent via pgsql-general mailing list (pg
On 09/15/2010 09:46 AM, Gary Fu wrote:
On 09/15/2010 02:28 AM, Sergey Konoplev wrote:
Hi,
On 15 September 2010 01:56, Gary Fu wrote
I have a function proc_TaskComplete that inserts a record to table
TaskHistory and then calls another function proc_ExportTaskComplete,
that
will retrieve
On 09/15/2010 02:28 AM, Sergey Konoplev wrote:
Hi,
On 15 September 2010 01:56, Gary Fu wrote
I have a function proc_TaskComplete that inserts a record to table
TaskHistory and then calls another function proc_ExportTaskComplete, that
will retrieve (select) the record just inserted based on an
Hi,
I have a function proc_TaskComplete that inserts a record to table
TaskHistory and then calls another function proc_ExportTaskComplete,
that will retrieve (select) the record just inserted based on an index
column (TaskId) in that table TaskHistory. I noticed that the select
sql (inside
Hi,
I have a simple perl program (see below) with DBI call to connect to the
Postgresql db on a CentOS system. I don't know why the top command
shows it takes more than 110m (under VIRT column). I tried with newer
DBI and DBD versions still have the same result. However, I tried it on
host
On 07/27/2010 10:20 PM, Tom Lane wrote:
Gary Fu writes:
Below is an example that I created. It works okay, but when I add any
character in the comment or in the table definition, it fails (hangs).
I checked the server process (with ps command), and I can see that
connection is 'idle'
On 07/22/2010 09:02 PM, Andy Colson wrote:
On 07/22/2010 04:03 PM, Gary Fu wrote:
Hi,
System information:
- psql 8.4.4 on a client with CentOS 5.5 (64 bits)
- postgres 8.4.4 on the server with CentOS 5.5 (64 bits)
- the client is connected with vpn
I have a script to create a table with some
Hi,
System information:
- psql 8.4.4 on a client with CentOS 5.5 (64 bits)
- postgres 8.4.4 on the server with CentOS 5.5 (64 bits)
- the client is connected with vpn
I have a script to create a table with some comments in front. When I
use the command 'psql -f script.sql' to load it, it hangs
Nilesh Govindarajan wrote:
On Tue, May 25, 2010 at 7:48 PM, Gary Fu wrote:
Hi,
On my mandriva linux, I don't have problem to build pgpool 2.3.3 with
postgresql 8.4.2. But when I upgraded to 8.4.4, I cannot build pgpool again
due to the libdl.so is not required in libpq.so (from th
Hi,
On my mandriva linux, I don't have problem to build pgpool 2.3.3 with
postgresql 8.4.2. But when I upgraded to 8.4.4, I cannot build pgpool
again due to the libdl.so is not required in libpq.so (from the ldd
command). Do you know how to build the 8.4.4 so that libdl.so is
required in li
Tom Lane wrote:
Gary Fu <[EMAIL PROTECTED]> writes:
My question now is why those temporary schemas won't be cleaned
after I restart the db ?
Just leave them alone and you'll be fine. These tools actually have
had most of the bugs worked out of them ;-) ... if you think pg_
Gary Fu wrote:
I tried to use pg_dump to restore (sync) a database, but I noticed that
the system table pg_namespace was not synced.
If you restore a database, entries in pg_namespace will be created if
the dump contains any CREATE SCHEMA statements, i.e. if there are
schemas in your
Hi,
I tried to use pg_dump to restore (sync) a database, but I noticed that
the system table pg_namespace was not synced.
I tried the following pg_dump command to just restore that table without
success either.
Does pg_dump support for the system tables or something I missed ?
Is there anothe
Scott Marlowe wrote:
Gary Fu wrote:
hello,
I try to allocate a chunk of ids from a sequence with the following
proc. However, if I don't use the 'lock lock_table', the proc may not
work when it runs at the same time by different psql sessions. Is
there a better way wi
hello,
I try to allocate a chunk of ids from a sequence with the following
proc. However, if I don't use the 'lock lock_table', the proc may not
work when it runs at the same time by different psql sessions. Is there
a better way without using the 'lock lock_table' ?
Thanks,
Gary
create o
25 matches
Mail list logo
