ubuntu server 12 which will be updated as well later this
> quarter.
>
Do you have a test environment? If I were you I would have a non-prod that
mimics my production setup exactly and I would apply the patch there first.
--
--
Best Regards,
*Sameer Kumar | Senior Solution Architect*
On Fri, 16 Dec 2016, 12:10 a.m. Sameer Kumar, <sameer.ku...@ashnik.com>
wrote:
> Hi,
>
> I was wondering if there is some change in the way
> max_standby_streaming_delay and hot_standby_feedback work in v9.5.
>
> Below is a scenario which I had built to test out some
hot_standby_feedback is off, I might face an issue with
rows being removed by vacuum. But that did not happen. Can someone help me
to understand how MVCC, autovacuum work with Streaming replication.
Regards
Sameer
--
--
Best Regards,
*Sameer Kumar | DB Solution Architect*
*ASHNIK PTE. LTD.*
101 Cecil
Hello,
> >
>
> Hello
>
> > We need some help on how we can migrate data from DB2 zOS database to
> > postgres database.
> >
> > Are there any utilities present? Any thoughts how we should approach?
>
> You can use this utility: https://github.com/dali
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards,
*Sameer Kumar | DB Solution Architect*
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong
iption:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards,
*Sameer Kumar | DB Solution Architect*
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
T: +65 6438 3504 | www.ashnik.com
Skype: sameer.ashnik | T: +65 8110 0350
[image: www.ashnik.com] <http://www.ashnik.com/>
CT date_trunc('day', tasks_start at TIME ZONE 'EST')
Note: I have not tried this statement
Is this something you are going to use often? If that is the case then
consider to re-model your query. The moment you use an expression on a
column it would not use a normal BTree index.
> but it doesn
mponents
of Elastic Stack like logstash and beats. They can be helpful even when you
use Postgres as the end point. Otherwise (IMHO), you would spend a lot of
time writing scripts and jobs to capture and stream logs. If I were you, I
would not want to do that.
> Regards,
>Thomas Güttle
e end, PG or ES, all depends on what you want.
>
> -Andy
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350
Skype: sameer.ashnik | www.ashnik.com
would you
want to do with this data once it is in Postgres.
> Regards,
> Thomas
>
>
> --
> Thomas Guettler http://www.thomas-guettler.de/
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http:/
On Fri, Aug 19, 2016 at 2:25 PM Victor Blomqvist <v...@viblo.se> wrote:
> On Fri, Aug 19, 2016 at 1:31 PM, Sameer Kumar <sameer.ku...@ashnik.com>
> wrote:
>
>>
>>
>> On Fri, 19 Aug 2016, 1:07 p.m. Victor Blomqvist, <v...@viblo.se> wrote:
>>
>&
;
Have you checked the TABLESAMPLE clause in v9.5?
https://wiki.postgresql.org/wiki/TABLESAMPLE_Implementation
> Thanks!
> /Victor
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350
Skype: sameer.ashnik | www.ashnik.com
d also be good. A separate audit table for each table would
> generally be a good idea, which makes it easy for tracking activities.
>
> Regards,
> Venkata B N
>
> Fujitsu Australia
>
> --
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350
Skype: sameer.ashnik | www.ashnik.com
ge portions of a table at once - it might
lead a page level lock which might conflict with SELECT/share locks on
standby
2. Any REINDEX operations
3. DDL operation
4. VACUUM FULL
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350
Skype: sameer.ashnik | www.ashnik.com
On Wed, Aug 17, 2016 at 12:00 PM Venkata B Nagothi <nag1...@gmail.com>
wrote:
> On Wed, Aug 17, 2016 at 1:31 PM, Sameer Kumar <sameer.ku...@ashnik.com>
> wrote:
>
>>
>>
>> On Wed, Aug 17, 2016 at 10:34 AM Patrick B <patrickbake...@gmail.com>
>>
On Wed, Aug 17, 2016 at 11:36 AM Patrick B <patrickbake...@gmail.com> wrote:
>
>
> 2016-08-17 15:31 GMT+12:00 Sameer Kumar <sameer.ku...@ashnik.com>:
>
>>
>>
>> On Wed, Aug 17, 2016 at 10:34 AM Patrick B <patrickbake...@gmail.com>
>> wrote:
to -1. But I would not recommend doing this if
you use your standby for other read queries or for high availability.
Another option would be avoid such queries which causes Exclusive Lock on
the master database during pg_dump.
Cheers
>
> Patrick
>
--
--
Best Regards
Sameer Kumar | DB Solution
--
> The contents of this email are confidential and may be subject to legal or
> professional privilege and copyright. No representation is made that this
> email is free of viruses or other defects. If you have received this
> communication in error, you may not copy or distribute any part of
ase 18363 after
> 3212.061 ms
> Aug 10 15:28:39 DB-1 postgres[3314]: [17-2] STATEMENT: INSERT INTO
>
> ActiveRadiussession(AccountSessionId,StationMAC,StationIP,StationIPV6,ApMAC,SSID,Username,WlanMAC,ChargeableUserIdentity,NASIPAddress,SessionStartTime,Port,
> ZoneWlanInfo, AppVMInstanceIP)
&g
On Tue, 26 Jul 2016, 9:20 p.m. Dev Kumkar, <devdas.kum...@gmail.com> wrote:
> On Tue, Jul 26, 2016 at 6:29 PM, Sameer Kumar <sameer.ku...@ashnik.com>
> wrote:
>
> You mean you don't want any routines/functions written in Pl/perl or
>> PL/pythin to get execu
you please suggest ways to achieve this?
>
> Regards...
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
On Mon, 25 Jul 2016, 10:35 p.m. Adrian Klaver, <adrian.kla...@aklaver.com>
wrote:
> On 07/25/2016 07:28 AM, Sameer Kumar wrote:
> >
> >
> > On Mon, 25 Jul 2016, 10:10 p.m. Adrian Klaver,
> > <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>&
On Mon, 25 Jul 2016, 10:10 p.m. Adrian Klaver, <adrian.kla...@aklaver.com>
wrote:
> On 07/24/2016 09:58 PM, Sameer Kumar wrote:
> > Hi,
> >
> > I have PostgreSQL v9.4.4 running in my environment. It has been up for
> > over 2 years now. I noticed that sudden
argest value is from pg_stat_user_tables.
tup_returned (470440261405). Does the statistics get reset automatically
when the value for one of the statistics reaches the high number supported
by int4?
I am running on Red Hat 6.7.
Regards
Sameer
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*AS
gt; Iranians around here.
>
> About myself, I am German, currently traveling back and forth between
> Germany and Malaysia.
>
> Torsten
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postg
atov
> Postgres Professional: http://www.postgrespro.com
> The Russian Postgres Company
>
>
> On 20.07.2016 21:02, Sameer Kumar wrote:
>
>
>
> On Thu, 21 Jul 2016, 1:17 a.m. Alex Ignatov, <a.igna...@postgrespro.ru>
> wrote:
>
>> Hello everyone!
>>
resql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
ables (cost=113.50..37914.64 rows=1
> width=1261) (actual time=779.261..29815.262 rows=909091 loops=1)
>Recheck Cond: (data @> '{"name": "AC3 Case Red"}'::jsonb)
>Rows Removed by Index Recheck: 4360296
>Heap Blocks: exact=37031 lossy=872059
>
ffers = 8GB
> work_mem = 42MB
> maintenance_work_mem = 2GB
> effective_cache_size = 44GB
>
>
what are the values of random_page_cost and seq_page_cost?
Also what might help here is the number of rows and pages in the table -
select relpages,reltuples, relname from pg_class where reln
couldn't use the directory -Fd dump because it's postgresql 9.1.
> The original database is still on the server, this is a test restore.
>
> We have about one or two months of slack before we really need to remove
> them from the server to recover space.
>
>
> --
> Miguel Ramos
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
sily. If the target one is not postgres I would use it
> too, but pass the COPY data through a perl script to generate whatever
> syntax the target DB needs ( I've done that to go from postgres to sql
> server and back using freebcp, IIRC, on the sql server side )
>
> You still can h
es to sql
> server and back using freebcp, IIRC, on the sql server side )
>
> You still can have problems IF you have updates to the tables, or
> deletions, or . But
> if you just have insertions, copy is easy to do.
>
> Francisco Olarte.
>
>
> --
> Sent via pgsql-general maili
like TeamViewer or WebEx etc over slow network
> Dmitry Shalashov, surfingbird.ru & relap.io
>
> 2016-07-07 20:26 GMT+03:00 Sameer Kumar <sameer.ku...@ashnik.com>:
>
>>
>>
>> On Fri, 8 Jul 2016, 1:23 a.m. Dmitry Shalashov, <skau...@gmail.com>
>> w
; Unclosed quotes, unclosed parenthesis - anyway it wont work.
>
> How to safely insert big number of statements to psql at once?
> I am aware about "execute this file" \i option of psql, that is not the
> answer I am looking for, thanks :-)
>
What are you exactly aiming to
On Thu, Jul 7, 2016 at 11:37 AM Patrick B <patrickbake...@gmail.com> wrote:
> 2016-07-07 15:19 GMT+12:00 Sameer Kumar <sameer.ku...@ashnik.com>:
>
>>
>>
>> On Thu, Jul 7, 2016 at 11:02 AM Patrick B <patrickbake...@gmail.com>
>> wrote:
>>
On Thu, Jul 7, 2016 at 11:02 AM Patrick B <patrickbake...@gmail.com> wrote:
> 2016-07-07 14:55 GMT+12:00 Sameer Kumar <sameer.ku...@ashnik.com>:
>
>>
>>
>> On Thu, 7 Jul 2016, 10:32 a.m. Patrick B, <patrickbake...@gmail.com>
>> wrote:
>>
>&
up thread.
1. Copy the archives generated on master to a shared location or may be
copy it to S3 bucket
2. Archive generated on master is rsync (schedule basis) to EC2
3. pg_receivexlog running on EC2 to copy WAL from slave01
can just be a archive_command and archive_mode = on?
>
Setting thes
l the problem with timeline, and slave02 won't be able to
> become a master in the future.
>
No, you should not have a problem. Since rsync will also copy the timeline
related files to slave02
> Is that right?
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. L
On Thu, 7 Jul 2016, 9:59 a.m. John R Pierce, <pie...@hogranch.com> wrote:
> On 7/6/2016 6:52 PM, Sameer Kumar wrote:
>
>
>> the only way to archive the wal_files from a slave into another slave on
>> PostgreSQL 9.2, is by using pg_reveivexlog?
>>
>
> Yes
On Thu, 7 Jul 2016, 9:52 a.m. Sameer Kumar, <sameer.ku...@ashnik.com> wrote:
>
>
> On Thu, 7 Jul 2016, 9:51 a.m. Patrick B, <patrickbake...@gmail.com> wrote:
>
>>
>>>
>>> On Thu, 7 Jul 2016, 9:20 a.m. Patrick B, <patrickbake...@gmail.com>
&
_senders on slave01 will be
>> 2(what you have set now) + 1 (for pg_reveivexlog)
>>
>>
>
> ok.. got a little confused now.
>
I thought I did my best to explain :)
> the only way to archive the wal_files from a slave into another slave on
> PostgreSQL 9.2, is by using pg_reveivexlog?
>
Yes. Though I have never tried this myself but going by the theory, it
should work.
> --
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
think it should work even in cascaded mode). But
since it works using streaming protocol, max_wal_senders on slave01 will be
2(what you have set now) + 1 (for pg_reveivexlog)
> Cheers guys!
> Patrick
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil
big backup I would recommend using custom format (
> -Fc ), it's much more flexible ( andyou can have the sql script but
> asking pg_restore to generate it if you need it, but not the other way
> round ).
>
>
> Francisco Olarte.
>
>
> --
> Sent via pgsql-general
On Fri, 24 Jun 2016, 6:23 a.m. Jeff Janes, <jeff.ja...@gmail.com> wrote:
> On Thu, Jun 23, 2016 at 10:54 AM, Sameer Kumar <sameer.ku...@ashnik.com>
> wrote:
> >
> >
> > On Fri, 24 Jun 2016, 1:47 a.m. Jeff Janes, <jeff.ja...@gmail.com> wrote:
> >>
On Fri, 24 Jun 2016, 1:54 a.m. Sameer Kumar, <sameer.ku...@ashnik.com>
wrote:
>
>
> On Fri, 24 Jun 2016, 1:47 a.m. Jeff Janes, <jeff.ja...@gmail.com> wrote:
>
>> On Thu, Jun 23, 2016 at 8:14 AM, Sameer Kumar <sameer.ku...@ashnik.com>
>> wrote:
>>
On Fri, 24 Jun 2016, 1:47 a.m. Jeff Janes, <jeff.ja...@gmail.com> wrote:
> On Thu, Jun 23, 2016 at 8:14 AM, Sameer Kumar <sameer.ku...@ashnik.com>
> wrote:
> >
> > Hi,
> >
> > I just wanted to understand what are the commands which will acquire
>
On Thu, Jun 23, 2016 at 11:57 PM Adrian Klaver <adrian.kla...@aklaver.com>
wrote:
> On 06/23/2016 08:14 AM, Sameer Kumar wrote:
> >
> > Hi,
> >
> > I just wanted to understand what are the commands which will acquire
> > Access Exclusive Lock on a
(or no mode specified)
I am using PostgreSQL v9.4.
Regards
Sameer
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
rrency.
>
>
> On 06/22/2016 05:20 PM, Sameer Kumar wrote:
>
>
>
> On Wed, Jun 22, 2016 at 5:10 PM Vlad Arkhipov <arhi...@dc.baikal.ru>
> wrote:
>
>> Hello,
>>
>> I have a constraint that requires a table to be locked before checking
>> it
org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
-
> Johan Thomsen
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
; Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
Maybe you should try using an IP address instead of a
> > host name.
> >
> > David J.
> >
> >
> >
> >
> >
> > I've never used this tool so like everyone else I am guessing here
> > but having quick
abase)?
>
I am not sure if this is the reason or right use case for SET ROLE.
Using different users (either with same app server or different) is the
best way if ensuring data is not accessible across organizations.
> Are there other options?
>
> Profuse appreciation for your thoughts
On Fri, Jun 3, 2016 at 4:30 AM Stephen Frost <sfr...@snowman.net> wrote:
> * Sameer Kumar (sameer.ku...@ashnik.com) wrote:
> > On Fri, 3 Jun 2016, 12:14 a.m. Alex Ignatov, <a.igna...@postgrespro.ru>
> > wrote:
> > > Can I list all WAL files in pg_xlog b
stgrespro.com
> The Russian Postgres Company
>
>
> --
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
t; --
>> *Melvin Davidson*
>> I reserve the right to fantasize. Whether or not you
>> wish to share my fantasy is entirely up to you.
>>
>
>
>
> --
> --
> Scott Mead
> Sr. Architect
> *OpenSCG <http://openscg.com>*
> http://openscg.com
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
sql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
install?source=signature=en=alukaraju2...@gmail.com=22>
>
> On Mon, May 23, 2016 at 10:37 AM, Sameer Kumar <sameer.ku...@ashnik.com>
> wrote:
>
>>
>>
>> On Mon, 23 May 2016, 1:03 p.m. aluka raju, <alukaraju2...@gmail.com>
>> wrote:
>>
ju2...@gmail.com=22>
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
e date time of the file when it was created.
Though I don't think this infra has been built for this very purpose.
> --
> john r pierce, recycling bits in santa cruz
>
> --
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
CTE instead
if bested select and use that with OUTER JOIN or may be in the inner query
use a correlated where clause (where t1.c2=t2.c2)
> to get me the output desired.
>
> Thanks
> Shankha Banerjee
>
>
> On Wed, May 18, 2016 at 1:57 PM, Sameer Kumar <sameer.ku...@ashnik.com
Output is :
>
> c1 | c2 | array_to_string
> ++-
> 2 | 20 | 2,3
> 1 | 10 | 2,3
> 3 | 30 | 2,3
>
> Could one of you help me with the correct query.
>
>
>
May you should share some more details of exactly what you are expecting
and what i
e at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
ing ?
>
> You need to shutdown master first, then promote slave and then other way
> round, but, this can be clarified only if you let us know the postgresql
> version. This is quite tricky in 9.2.x and from 9.3.x.
>
> Regards,
> Venkata B N
>
> Fujitsu Australia
>
>
> --
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
On Tue, May 10, 2016 at 4:36 PM Sameer Kumar <sameer.ku...@ashnik.com>
wrote:
> On Tue, May 10, 2016 at 4:26 PM Nicolas Paris <nipari...@gmail.com> wrote:
>
>> Hello,
>>
>> What is the way to build a binary format (instead of a csv) ? Is there
>
?
>
> I guess this would be far faster, and maybe safer than CSVs
>
I don't think assumption is right. COPY is not meant for backup, it is for
LOAD and UN-LOAD.
What you probably need is pg_dump with -Fc format.
http://www.postgresql.org/docs/current/static/app-pgdump.html
>
> Thank
rows-affected-tp5902708.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
or bloat calculation out there that are worth
> investigating.
>
>
> David J.
>
> --
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
erhaps a reindex might help.
> "idx_scan", "idx_tup_read" and "idx_tup_fetch" are 0.
> So, it's safe to say that they are not being used, is that right?
>
> But some indexes have almost 100GB on the size column. This means they are
> not being used
l is
> strictly prohibited. If you have
> received this email in error please delete it and notify the sender
> immediately. .
>
> ---
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
t;
> Some important postgresql.conf readouts:
>
> - shared_buffers = 4GB
> - work_mem = 64MB
> - maintenance_work_mem = 1GB
> - checkpoint_segments = 50
> - checkpoint_completion_target = 0.9
> - autovacuum = on
>
> Is there something I am missing here? Any help on getting this join faster
> is much appreciated.
>
> Cheers,
> Tim
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
eral mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
queries related to the same table(s)?
Which version of PostgreSQL? What's the version of OS?
Check out the locks which are not granted yet - pg_locks.granted
> Your help is appreciated.
>
> Thanks and regards,
> Vineel.
>
> --
--
Best Regards
Sameer Kumar | DB Solution Architect
*
nking that a
> scripted Ansible/Vagrant setup makes sense.
>
I am not sure if it is because of that but you are on an old patch. Upgrade
to latest (I guess 9.1.21).
Once you have upgraded, re-create the stand by from scratch using a
basebackup and then see if the error is still there.
>
ling list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
On Thu, Jul 2, 2015 at 9:57 PM Lukasz Wrobel
lukasz.wro...@motorolasolutions.com wrote:
Hello again.
Thank you for all your responses. I will try to clarify more and attempt
to answer the questions you raised.
I'm attaching the postgresql.conf this time. I cannot supply you guys with
a
On Wed, Jul 1, 2015 at 3:37 AM Lukasz Wrobel
lukasz.wro...@motorolasolutions.com wrote:
Hello.
I have multiple problems with my database, the biggest of which is how to
find out what is actually wrong.
First of all I have a 9.3 postgres database that is running for about a
month. Right
On Wed, Jul 1, 2015 at 4:51 AM Pavel Stehule pavel.steh...@gmail.com
wrote:
Hi
What is an output of VACUUM VERBOSE statement?
VACUUM can be blocked by some forgotten transaction. Check your
pg_stat_activity table for some old process in idle in transaction state.
Then connection should not
On Fri, 19 Jun 2015 13:46 Michael Paquier michael.paqu...@gmail.com wrote:
On Fri, Jun 19, 2015 at 2:38 PM, James Sewell james.sew...@lisasoft.com
wrote:
Hey All,
Is it possible to create WAL archive files on standby servers when using
streaming replication?
Yes and no, standbys do not
On Thu, 18 Jun 2015 15:17 Xavier 12 mania...@gmail.com wrote:
On 18/06/2015 04:00, Sameer Kumar wrote:
On Wed, 17 Jun 2015 15:24 Xavier 12 mania...@gmail.com wrote:
On 17/06/2015 03:17, Sameer Kumar wrote:
On Tue, 16 Jun 2015 16:55 Xavier 12 mania...@gmail.com wrote:
Hi everyone
On Wed, 17 Jun 2015 15:24 Xavier 12 mania...@gmail.com wrote:
On 17/06/2015 03:17, Sameer Kumar wrote:
On Tue, 16 Jun 2015 16:55 Xavier 12 mania...@gmail.com wrote:
Hi everyone,
Questions about pg_xlogs again...
I have two Postgresql 9.1 servers in a master/slave stream replication
On Tue, 16 Jun 2015 16:55 Xavier 12 mania...@gmail.com wrote:
Hi everyone,
Questions about pg_xlogs again...
I have two Postgresql 9.1 servers in a master/slave stream replication
(hot_standby).
Psql01 (master) is backuped with Barman and pg_xlogs is correctly
purged (archive_command is used).
On Fri, May 8, 2015 at 2:29 PM James Sewell james.sew...@lisasoft.com
wrote:
Hello All,
I am running 9.4 on Centos.
I have three servers, one master and two slaves. The slaves have the
following recovery.conf
standby_mode = 'on'
primary_conninfo = 'user=postgres host=mastervip port=5432'
On Tue, May 5, 2015 at 1:44 PM David G. Johnston david.g.johns...@gmail.com
wrote:
On Mon, May 4, 2015 at 10:23 PM, Sameer Kumar sameer.ku...@ashnik.com
wrote:
Sorry about the long silence on this.
On Mon, Apr 13, 2015 at 3:34 PM David G. Johnston
david.g.johns...@gmail.com wrote
Sorry about the long silence on this.
On Mon, Apr 13, 2015 at 3:34 PM David G. Johnston
david.g.johns...@gmail.com wrote:
On Sun, Apr 12, 2015 at 10:23 PM, Sameer Kumar sameer.ku...@ashnik.com
wrote:
On Mon, Apr 13, 2015 at 1:03 PM Jim Nasby jim.na...@bluetreble.com
wrote:
No. I suspect
On Tue, 14 Apr 2015 11:59 Ilya Ashchepkov koc...@gmail.com wrote:
On Mon, 13 Apr 2015 12:24:11 -0700
Adrian Klaver adrian.kla...@aklaver.com wrote:
On 04/13/2015 11:25 AM, Ilya Ashchepkov wrote:
On Mon, 13 Apr 2015 10:06:05 -0700
Adrian Klaver adrian.kla...@aklaver.com wrote:
On
On Mon, 13 Apr 2015 11:35 Jim Nasby jim.na...@bluetreble.com wrote:
On 4/11/15 4:11 PM, Sameer Kumar wrote:
Pg_settings currently has an upper bound column - though it is a
view and that value cannot be changed that I know of.
I guess that upper bound column is more of the limit
On Mon, Apr 13, 2015 at 1:03 PM Jim Nasby jim.na...@bluetreble.com wrote:
On 4/12/15 11:55 PM, Sameer Kumar wrote:
On Mon, 13 Apr 2015 11:35 Jim Nasby jim.na...@bluetreble.com
mailto:jim.na...@bluetreble.com wrote:
On 4/11/15 4:11 PM, Sameer Kumar wrote:
Pg_settings
On Sat, 11 Apr 2015 16:05 David G. Johnston david.g.johns...@gmail.com
wrote:
On Friday, April 10, 2015, Sameer Kumar sameer.ku...@ashnik.com wrote:
On Sat, Apr 11, 2015 at 12:57 AM David G. Johnston
david.g.johns...@gmail.com wrote:
On Fri, Apr 10, 2015 at 9:01 AM, Sameer Kumar sameer.ku
On Sat, Apr 11, 2015 at 12:57 AM David G. Johnston
david.g.johns...@gmail.com wrote:
On Fri, Apr 10, 2015 at 9:01 AM, Sameer Kumar sameer.ku...@ashnik.com
wrote:
Hi,
In PostgreSQL a user can alter itself to change its user level
parameters. e.g. I can alter the user to change work_mem
column-
alter table table_name alter column column_Name set statistics 1000;
analyze table_name;
Best Regards,
*Sameer Kumar | Database Consultant*
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M: *+65 8110 0350* T: +65 6438 3504 | www.ashnik.com
*[image
are the values for below parameters-
- random_page_cost
- seq_page_cost
- effective_cache_size
I already did an analyze on the table.
Best Regards,
*Sameer Kumar | Database Consultant*
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M: *+65 8110 0350* T: +65
check of the database on the standby
utilizing the nature of the data instead?
Best Regards,
*Sameer Kumar | Database Consultant*
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M: *+65 8110 0350* T: +65 6438 3504 | www.ashnik.com
*[image: icons
On Wed, Jan 14, 2015 at 2:11 AM, Heikki Linnakangas hlinnakan...@vmware.com
wrote:
On 01/13/2015 12:11 PM, Vladimir Borodin wrote:
05 янв. 2015 г., в 18:15, Vladimir Borodin r...@simply.name написал(а):
Hi all.
I have a simple script for planned switchover of PostgreSQL (9.3 and
9.4)
to. Otherwise you will be looking at increasingly convoluted methods
of getting two bodies to occupy one space.
+1
I agree...
Best Regards,
*Sameer Kumar | Database Consultant*
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M: *+65 8110 0350* T: +65
On 6 Jan 2015 03:02, tuanhoanganh hatua...@gmail.com wrote:
Hello everybody
Does anyone user pg-pool II on real production ?
Yes we have a customer using it in load balancing mode and another one
using it with Watchdog for high availability.
How many slave do you have? and how many size of
1 - 100 of 171 matches
Mail list logo