On Thu, Nov 24, 2016 at 5:44 PM, Yogesh Sharma <
yogesh1.sha...@nectechnologies.in> wrote:
> Dear All,
>
> Thanks in advance.
> I found below deadlock in postgresql logs.
> I cannot change calling of REINDEX and insert query sequence because it is
> execute automatically through some cron script.
Yogesh Sharma writes:
> ERROR: deadlock detected
> DETAIL: Process 2234 waits for AccessShareLock on relation 16459 of
> database 16385; blocked by process 4111.
> Process 4111 waits for ShareLock on relation 16502 of database 16385;
> blocked by process 2234.
> Process 2234: INSERT INTO ta
> If it is possible?
>
> Regards,
> Yogesh
>
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
> Sent: Friday, November 25, 2016 10:55 AM
> To: pgsql-general@postgresql.org
On Fri, Nov 25, 2016 at 11:14 AM, Sameer Kumar wrote:
> Does this mean that you reindex quite often based on a schedule. Personally I
> don't prefer that. To me it is like you are trying to fix something that is
> not broken.
>
> Ideally reindex only what needs to be reindexed. I would not want
.
Regards,
Yogesh
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
Sent: Friday, November 25, 2016 10:55 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Query regarding deadlock
On 11/24/2016 5:44
On Fri, 25 Nov 2016, 9:45 a.m. Yogesh Sharma, <
yogesh1.sha...@nectechnologies.in> wrote:
> Dear All,
>
> Thanks in advance.
> I found below deadlock in postgresql logs.
> I cannot change calling of REINDEX and insert query sequence because it is
> execute automatically through some cron script.
>
is possible?
Regards,
Yogesh
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
Sent: Friday, November 25, 2016 10:55 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Query regarding deadlock
On 11
On 11/24/2016 5:44 PM, Yogesh Sharma wrote:
I cannot change calling of REINDEX and insert query sequence because it is
execute automatically through some cron script.
any cron scripts are your own doing, so this statement makes no sense at
all.
--
john r pierce, recycling bits in santa cru
Hi,
On Wed, Nov 4, 2015 at 1:21 AM, M Tarkeshwar Rao <
m.tarkeshwar@ericsson.com> wrote:
> Hi all,
>
> We have started to convert some oracle sql scripts and converting them to
> postgres, but facing some issues to create table.
>
> I have some common doubts in create table script ie.
>
> ALT
M Tarkeshwar Rao schrieb am 04.11.2015 um 10:21:
> Hi all,
>
> We have started to convert some oracle sql scripts and converting them to
> postgres, but facing some issues to create table.
>
> I have some common doubts in create table script ie.
>
> ALTER TABLE employee
> DROP PRIMARY KEY CA
Le 4 nov. 2015 10:23 AM, "M Tarkeshwar Rao"
a écrit :
>
> Hi all,
>
> We have started to convert some oracle sql scripts and converting them to
postgres, but facing some issues to create table.
>
> I have some common doubts in create table script ie.
>
> ALTER TABLE employee
> DROP PRIMARY KEY CAS
Ajit Pradnyavant writes:
> I think result of INTERSECT ALL query may be :
> Srno Name
> 1 Aaaa
> 1 Aaaa
> Because intersect all clause returns the duplicate values.
No; per the documentation at
http://www.postgresql.org/docs/9.1/static/sql-select.html#SQL-INTERSECT
The result
Vikash3 S wrote:
> Would like to submit patch on this TO Do list item which deals with
psql client, "psql : Allow
> processing of multiple -f (file) options ".
>
> The code base which I am working on is from postgres 9.1.3 release.
> But when I diff the code base from git repository, the changes a
On 18/08/2011 11:52 AM, Navin Chandra wrote:
Hi,
I am an application developer, want to use ‘PostGre’ as backend. May I
know what is the maximum possible number of concurrent users?
Your acknowledgement will be highly appreciated.
You seem to have replied to yourself. Eh?
There's no such thin
On Wed, Aug 17, 2011 at 9:52 PM, Navin Chandra
wrote:
> Hi,
>
> I am an application developer, want to use ‘PostGre’ as backend. May I know
> what is the maximum possible number of concurrent users?
> Your acknowledgement will be highly appreciated.
FYI, we call it PostgreSQL or pgsql around here
On 08/17/11 8:52 PM, Navin Chandra wrote:
I am an application developer, want to use ‘PostGre’ as backend.
Please note, there is no such thing as PostGre. There is PostgreSQL,
sometimes called Postgres for short.
May I know what is the maximum possible number of concurrent users?
A better
On Thu, 17 Jul 2003, Kallol Nandi wrote:
> How can I have a scheduled vacuum and backup of the databases in PostgreSql.
> Does someone know it already?
> I need it urgently.
Use cron (I assume you're running Unix.)
A simple crontab entry to run 'vacuumdb -a -z -f' and pg_dump should do.
'man cr
17 matches
Mail list logo
