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
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.
ERROR: deadlock detected
DETAIL: Process 2234 waits for AccessShareLock on relation 16459 of datab
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
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 CASCADE;
DROP employee CASCADE CONSTRAINTS;
CREATE TABLE employee
(
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
Sir,
I have created the following tables,
Create table abc (srno int, name varchar(32))
Create table def (srno int, name varchar(32))
abc
srnoname
1 Aaaa
2 Bbbb
def
srnoname
1 Aaaa
2 Cccc
each having two tuples.
If I run the following query I get the fo
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
Hi,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 are far different from the
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
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.
Thanks & Regards,
Navin Pandit
Gurgaon- 122 001
(India)
From: selenama...@gmail.com [mailto:selenama...@
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
22 matches
Mail list logo
