>
> Yes, we do see statements being canceled from time to time, just not when
> we experience a lag situation with WALs not being applied. Is it just
> entirely possible that there is too much work for one of the slaves to do
> (hence the degraded query throughput we see) that it is unable to apply
On Thu, Mar 20, 2014 at 11:27 PM, Granthana Biswas wrote:
> Hello All,
>
> Has anyone ever faced the issue of dead rows not getting removed during
> vacuum even if there are no open transactions/connections?
>
> We have been facing this during every scheduled vacuum which is done after
> closing a
On Thu, Mar 20, 2014 at 5:27 AM, Granthana Biswas wrote:
> Has anyone ever faced the issue of dead rows not getting removed during
> vacuum even if there are no open transactions/connections?
What does the pg_prepared_xacts view show?
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and D
On 3/20/2014 4:45 PM, Raymond O'Donnell wrote:
On 20/03/2014 07:48, Bhim Kumar wrote:
Hi sir
Currently I am using following query on mysql :
* SHOW TABLES; ---> To get list of table in a particular db.
Assuming you're using psql, did you take the advice you're given on
connection and type
On 20/03/2014 07:48, Bhim Kumar wrote:
> Hi sir
>
> Currently I am using following query on mysql :
>
> * SHOW TABLES; ---> To get list of table in a particular db.
Assuming you're using psql, did you take the advice you're given on
connection and type "help"?
Anyway, to see a list of tables
On Thu, Mar 20, 2014 at 5:27 AM, Granthana Biswas wrote:
Hello All,
>
> Has anyone ever faced the issue of dead rows not getting removed during
> vacuum even if there are no open transactions/connections?
>
> We have been facing this during every scheduled vacuum which is done after
> closing all
Hello All,
Has anyone ever faced the issue of dead rows not getting removed during
vacuum even if there are no open transactions/connections?
We have been facing this during every scheduled vacuum which is done after
closing all other database connections:
119278 dead row versions cannot be remo
Hi sir
Currently I am using following query on mysql :
* SHOW TABLES; ---> To get list of table in a particular db.
*
SELECT TABLE_NAME, CONSTRAINT_NAME, COLUMN_NAME,
REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME from
information_schema.key_column_usage WHERE constraint_schema
='myDBName';
Is pljava totally dead? Is anyone still contributing to this?
Buildling pljava is becoming increasingly difficult and impossible.
We're looking into converting our Oracle base to psql, but this is a real
obstacle for us as we've got a number of oracle java stored procedures, and
would truly pref
Hello,
I rarely post in this group, but felt input would be important to chime in
here from a security aspect.
One of the primary challenges I've seen in the past with migrating to
PostgreSQL from Oracle is implementing DISA STIG compliance. This may or
may not be a requirement in your environme
On Thu, Mar 20, 2014 at 5:48 AM, basti wrote:
> at the moment we use a Postgres Server as Master and one as Hot-Standby.
> The Database is around 50GB and will massive grow next time.
>
> Backup and Restore with pg_dump take several hours, is there a faster
> way to do this?
Where does pg_backup
Hello,
at the moment we use a Postgres (9.1) Master and a Hot-Standby with WAL
Replication.
We also use Slony to copy some (not all) Tables to fronted server.
Is it possible to use repmgr to switch between Master and Hot-standby
without lose the slony functionality?
When I use repmgr and switch
On Thu, Mar 20, 2014 at 9:48 PM, basti wrote:
> at the moment we use a Postgres Server as Master and one as Hot-Standby.
> The Database is around 50GB and will massive grow next time.
>
> Backup and Restore with pg_dump take several hours, is there a faster
> way to do this?
Everything is here:
ht
Hi Dennis,
I already manage. The problem as because I wasn't in the right folder...rookie
mistake.
Thank you for your email.
Regards,
José Santos
From: den...@kabonkulator.com
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Dump Database
Date: Mon, 17 Mar 2014 08:14:03 -0500
What
Le 2014-03-19 à 19:48, Adrian Klaver a écrit :
> On 03/19/2014 02:01 PM, François Beausoleil wrote:
>
> Some experimenting showed that NEW.* does not work. So plan B:
>
>
> EXECUTE 'SELECT $1.' || TG_ARGV[0] || INTO total USING NEW;
> RAISE EXCEPTION 'Total: %, social_impressions: %', total,
Hello,
at the moment we use a Postgres Server as Master and one as Hot-Standby.
The Database is around 50GB and will massive grow next time.
Backup and Restore with pg_dump take several hours, is there a faster
way to do this?
Regards,
Basti
--
Sent via pgsql-general mailing list (pgsql-genera
On Wed, Mar 19, 2014 at 11:31 PM, Venkata Balaji Nagothi
wrote:
> On Thu, Mar 20, 2014 at 8:19 AM, Shaun Duncan wrote:
>
>>
>> On Mar 19, 2014 5:08 PM, "Venkata Balaji Nagothi"
>> wrote:
>> >
>> >
>> > On Thu, Mar 20, 2014 at 4:12 AM, Shaun Duncan
>> wrote:
>> >
>> >> This is on a production 9.0
On Thu, 20 Mar 2014 09:14:29 +0900
Michael Paquier wrote:
> You should be careful not to give ideas away. There may be enough
> funds to really create a high-tech-funky suit like that :)
> --
> Michael
Hackers has free time to spare in funky projects, Big Corps has free money to
spare in funky
18 matches
Mail list logo
