Good morning
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of hamann.w@t-
> online.de
> Sent: Samstag, 9. Juli 2016 08:20
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Running query without trigger?
>
>
Hi,
a table is associated with a trigger for normal use.
An admin (someone with ALTER privilege) can disable tthe trigger, run some bulk
update,
and then re-enable it. This means, however, that normal user activity has to
be locked out.
There are two possible scenarios: the bulk update would
On 7/8/2016 12:00 PM, Karl Czajkowski wrote:
3. Rewrite or refactor such complex stored procedures in a different
programming language such as C or Python, so your PL/pgsql stored
procedures remain small glue around libraries of code. Postgres
makes it very trivial to extend the syst
On Jul 08, John McKown modulated:
...
> I think the "problem" that he is having is fixable only by changing how
> PostgreSQL itself works. His problem is a PL/pgSQL function which is
> 11K lines in length. When invoked, this function is "compiled" into a
> large tokenized parse tree. This parse tre
On 7/8/2016 11:52 AM, Paul Tilles - NOAA Federal wrote:
I am currently running Version 9.3.10 of postgres with RHEL 6. I am
going to upgrade my O/S soon to RHEL 7. Do I need to upgrade to
version 9.4.x of postgres?
was 9.3 installed from the PGDG yum repository, or from the default RHEL
repo
I am currently running Version 9.3.10 of postgres with RHEL 6. I am going
to upgrade my O/S soon to RHEL 7. Do I need to upgrade to version 9.4.x of
postgres?
Paul Tilles
Tom Lane wrote:
> Francisco Olarte writes:
> > On Thu, Jul 7, 2016 at 8:18 PM, Alvaro Herrera
> > wrote:
> >> I've wished sometimes for a "\set READLINE off" psql metacommand for
> >> this kind of thing. It's pretty annoying when the text being pasted
> >> contains tabs and readline uses to do
2016-07-08 17:49 GMT+02:00 :
> Hi
>
>
> >> Oracle: about 5M
> >> postgreSql: about 160М
>
>
>
> >The almost session memory is used for catalog caches. So you should to
> have big catalog and long living sessions.
>
> >What do you do exactly?
>
> I've generate test code that emulates instruction t
On Fri, Jul 8, 2016 at 11:26 AM, Melvin Davidson
wrote:
>
>
> On Fri, Jul 8, 2016 at 11:49 AM, wrote:
>
>> Hi
>>
>>
>> >> Oracle: about 5M
>> >> postgreSql: about 160М
>>
>>
>>
>> >The almost session memory is used for catalog caches. So you should to
>> have big catalog and long living sessions
On Fri, Jul 8, 2016 at 11:49 AM, wrote:
> Hi
>
>
> >> Oracle: about 5M
> >> postgreSql: about 160М
>
>
>
> >The almost session memory is used for catalog caches. So you should to
> have big catalog and long living sessions.
>
> >What do you do exactly?
>
> I've generate test code that emulates i
Title: Re: [GENERAL] Memory usage per session
Hi
>> Oracle: about 5M
>> postgreSql: about 160М
>The almost session memory is used for catalog caches. So you should to have big catalog and long living sessions.
>What do you do exactly?
I've generate test code that emulates instruction tre
Title: Re: [GENERAL] Memory usage per session
Hi
>> >> The test performs about 11K lines of code
>> >> Oracle: about 5M
>> >> postgreSql: about 160М
>What is the actual O/S that PostgreSQL is installed on?
>How much total memory is on the server?
>I would be very curious about the values you
On 08/07/2016 17:07, amatv...@bitec.ru wrote:
Hi
The test performs about 11K lines of code
Oracle: about 5M
postgreSql: about 160М
Do you have 100 CPUs on this system which apparently doesn't have 16G
of RAM available for PG to use?
We can say at fact:
We currently work at oracle.
Our code
On Fri, Jul 8, 2016 at 10:07 AM, wrote:
> Hi
>
> >> >> The test performs about 11K lines of code
> >> >> Oracle: about 5M
> >> >> postgreSql: about 160М
>
>
> > Do you have 100 CPUs on this system which apparently doesn't have 16G
> > of RAM available for PG to use?
> We can say at fact:
> We cur
Title: Re: [GENERAL] Memory usage per session
Здравствуйте.
>> Oracle: about 5M
>> postgreSql: about 160М
>I'm admittedly ignorant of this type of testing. But if the memory usage for PostgreSQL is in the server, perhaps due to caching (how to test?), then it likely would _not_ linearly scale
Francisco Olarte writes:
> On Thu, Jul 7, 2016 at 8:18 PM, Alvaro Herrera
> wrote:
>> I've wished sometimes for a "\set READLINE off" psql metacommand for
>> this kind of thing. It's pretty annoying when the text being pasted
>> contains tabs and readline uses to do completion.
> Doesn't 'cat
Hi
>> >> The test performs about 11K lines of code
>> >> Oracle: about 5M
>> >> postgreSql: about 160М
> Do you have 100 CPUs on this system which apparently doesn't have 16G
> of RAM available for PG to use?
We can say at fact:
We currently work at oracle.
Our code base about 4000 k line of co
* amatv...@bitec.ru (amatv...@bitec.ru) wrote:
> > On 08/07/2016 14:11, amatv...@bitec.ru wrote:
> >> The test performs about 11K lines of code
> >> Memory usage per session:
> >> Oracle: about 5M
> >> MSSqlServer: about 4M
> >> postgreSql: about 160М
>
> > Visual C???
> > You will have to run Pos
On Fri, Jul 8, 2016 at 8:16 AM, wrote:
> Hi
>
> > On 08/07/2016 14:11, amatv...@bitec.ru wrote:
> >> Hi.
> >> The test performs about 11K lines of code
> >> Memory usage per session:
> >> Oracle: about 5M
> >> MSSqlServer: about 4M
> >> postgreSql: about 160М
>
>
> > Visual C???
> > You will have
Hi
2016-07-08 15:16 GMT+02:00 :
> Hi
>
> > On 08/07/2016 14:11, amatv...@bitec.ru wrote:
> >> Hi.
> >> The test performs about 11K lines of code
> >> Memory usage per session:
> >> Oracle: about 5M
> >> MSSqlServer: about 4M
> >> postgreSql: about 160М
>
>
> > Visual C???
> > You will have to run
Hi
> On 08/07/2016 14:11, amatv...@bitec.ru wrote:
>> Hi.
>> The test performs about 11K lines of code
>> Memory usage per session:
>> Oracle: about 5M
>> MSSqlServer: about 4M
>> postgreSql: about 160М
> Visual C???
> You will have to run PostgreSQL on a proper Unix system to test for
> perfor
On Fri, 8 Jul 2016, 8:06 p.m. Prashanth Adiyodi,
wrote:
> Hi Sameer, Please see comments inline
>
>
>
>
>
> *Prashanth Adiyodi *
>
> *Technical Account Manager*
>
> *Skype: prashanth.adiyodi*
>
> *Mob: +91-9819488395*
>
> [image: celltick]
>
>
>
>
>
>
>
> *From:* Sameer Kumar [mailto:sameer.ku..
On 08/07/2016 14:11, amatv...@bitec.ru wrote:
Hi.
We have tested postgreSql,Oracle,MSSqlServer.
The test performs about 11K lines of code
Memory usage per session:
Oracle: about 5M
MSSqlServer: about 4M
postgreSql: about 160М
The result of postgreSql is very sad(Our typical business logic has abo
Hi.
We have tested postgreSql,Oracle,MSSqlServer.
The test performs about 11K lines of code
Memory usage per session:
Oracle: about 5M
MSSqlServer: about 4M
postgreSql: about 160М
The result of postgreSql is very sad(Our typical business logic has about 30K
lines of code).
How can I reduce memory
Hi:
On Thu, Jul 7, 2016 at 8:18 PM, Alvaro Herrera wrote:
>> You might have better luck with "psql -n", or maybe not.
> I've wished sometimes for a "\set READLINE off" psql metacommand for
> this kind of thing. It's pretty annoying when the text being pasted
> contains tabs and readline uses to
On Fri, Jul 8, 2016 at 5:38 PM Francisco Olarte
wrote:
> 1.- CCing to the list ( remember to hit reply-all or whatever your MUA
> uses for that, otherwise threads may get lost ).
>
> 2.- Try to avoid top-posting, it's not the style of the list ( or mine ).
>
> On Fri, Jul 8, 2016 at 4:43 AM, Pras
1.- CCing to the list ( remember to hit reply-all or whatever your MUA
uses for that, otherwise threads may get lost ).
2.- Try to avoid top-posting, it's not the style of the list ( or mine ).
On Fri, Jul 8, 2016 at 4:43 AM, Prashanth Adiyodi
wrote:
> Basically my requirement is, I have a live
27 matches
Mail list logo