On 08/25/2016 11:36 AM, Alex Lai wrote:
> Dear All,
>
> I have my log_line_prefix set to
> log_line_prefix = '[%d]%p %x %c[%l] %t %i'
> in postgresql.conf
>
> psql -c 'show timezone'
> TimeZone
>
> US/Eastern
>
> tai
eatly
appreciated.
--
Best regards,
Alex Lai (:-)
OMP SIPS DBA ADNET Systems, Inc.
7515 Mission Drive, Suite A100
Lanham, MD 20706
301 352-4657 (phone)
301 352-0437 (fax)
m...@sesda3.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscript
On 09/12/2013 10:09 AM, Giuseppe Broccolo wrote:
Il 11/09/2013 22:02, Alex Lai ha scritto:
I have been reading few posted comment about the risk for autovacuum
for older postgres liek version 8.
I am currently running 9.2.4. We have a need to terminate any query
running longer than 2 hours
e the risk of fail
autovacuum.
--
Best regards,
Alex Lai
OMI SIPS DBA ADNET Systems , Inc.
m...@sesda3.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
lanner is
confused which index to use.
I think this is should be considered as a bug for rule system related to
planner. I am not sure 9.2 will address this issue.
--
Best regards,
Alex Lai
OMI SIPS DBA ADNET Systems , Inc.
7515 Mission Drive,
Suite A100 Lanham, MD 20706
301-352-4657 (phone)
30
On 09/13/2012 09:59 AM, Tom Lane wrote:
Alex Lai writes:
"EXPLAIN insert into alex1 (fileid, archiveset) select 35352974, 10003;"
[vs]
"EXPLAIN insert into alex1 (fileid, archiveset) select '35352974', '10003';"
You might be happier using INSERT
-> Index Scan using
ak_filemeta_orbital_esdt_key on filemeta_orbital m (cost=0.00..3.60
rows=1 width=28)
Index Cond: (((esdt)::text
= (o.esdt)::text) AND ((key)::text = (o.key)::text))
-> Index Sca
join filename using(fileid)') as t2(filename text,esdt text,archiveset
int));
--
Best regards,
Alex Lai
OMI SIPS DBA ADNET Systems , Inc.
7515 Mission Drive,
Suite A100 Lanham, MD 20706
301-352-4657 (phone)
301-352-0437 (fax)
a...@sesda2.com
--
Sent via pgsql-general mailing list (pgsql
t) AND (endtime >= '2012-01-28
08:14:57'::timestamp without time zone) AND (endtime <= '2012-05-07 07
:41:27'::timestamp without time zone))
-> Index Scan using
pk_filemeta_archiveset on filemeta_archiveset a (cost=0.00..5.21 rows=1
widt
David Johnston wrote:
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alex Lai
Sent: Thursday, January 19, 2012 1:56 PM
To: postgres general support
Subject: [GENERAL] How to improve my slow query for table have list of
T'::text)
Filter: ((key)::text = '2011-10-08 07:09:47-04'::text)
-> Bitmap Index Scan on id_filemeta_orbital
(cost=0.00..95.13 rows=4173 width=0) (actual time=0.020..0.020 rows=0
loops=1)
Index Cond: ((esdt)::text = 'MET
roduction table.
--
Best regards,
Alex Lai
OMI SIPS DBA ADNET Systems , Inc.
7515 Mission Drive,
Suite A100 Lanham, MD 20706
301-352-4657 (phone)
301-352-0437 (fax)
a...@sesda2.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscript
id you set trigger_file in recovery? That is the required step to
switch slave to master. I set my log rotate+archive to 15 minutes.
When I touch fail over file, it mostly like force it to rotate+archive.
--
Best regards,
Alex Lai
OMI SIPS DBA ADNET Systems , Inc.
7515 Mission Drive,
S
changes after promote the slave to be master?
--
Best regards,
Alex Lai
OMI SIPS DBA ADNET Systems , Inc.
7515 Mission Drive,
Suite A100 Lanham, MD 20706
301-352-4657 (phone)
301-352-0437 (fax)
a...@sesda2.com
--
Sent via pgsql-general mailing list (pgsql-general@post
urging any
applied logs. What is the best way to manage the logs to save the disk
space? I also found my postgres does not have pg_archivecleanup
utility. Where do I find this utility? How do I use this utility?
Your help would be greatly appreciated.
--
Best regards,
Alex Lai
--
Sent
15 matches
Mail list logo
