Re: [PERFORM] More cores or higer frequency ?

2017-05-23 Thread Steve Crawford
On Tue, May 23, 2017 at 1:49 PM, Sven R. Kunze wrote: > On 23.05.2017 22:14, Jarek wrote: > >> I have pool of clients (~30) inserting to database about 50 records per >> second (in total from all clients) and small numer (<10) clients >> querying database for those records once

Re: [PERFORM] More cores or higer frequency ?

2017-05-23 Thread Scott Marlowe
On Tue, May 23, 2017 at 2:14 PM, Jarek wrote: > Dnia 2017-05-23, wto o godzinie 11:39 -0700, Steve Crawford pisze: >> The answer, as always, is "it depends." >> >> >> Can you give us an overview of your setup? The appropriate setup for >> small numbers of long-running

Re: [PERFORM] More cores or higer frequency ?

2017-05-23 Thread Sven R. Kunze
On 23.05.2017 22:14, Jarek wrote: I have pool of clients (~30) inserting to database about 50 records per second (in total from all clients) and small numer (<10) clients querying database for those records once per 10s. Other queries are rare and irregular. The biggest table has ~ 100mln

Re: [PERFORM] More cores or higer frequency ?

2017-05-23 Thread Jarek
Dnia 2017-05-23, wto o godzinie 11:39 -0700, Steve Crawford pisze: > The answer, as always, is "it depends." > > > Can you give us an overview of your setup? The appropriate setup for > small numbers of long-running analytical queries (typically faster > CPUs) will be different than a setup for

Re: [PERFORM] More cores or higer frequency ?

2017-05-23 Thread Steve Crawford
The answer, as always, is "it depends." Can you give us an overview of your setup? The appropriate setup for small numbers of long-running analytical queries (typically faster CPUs) will be different than a setup for handling numerous simultaneous connections (typically more cores). But CPU is

Re: [PERFORM] select subquery versus join subquery

2017-05-23 Thread Jeff Janes
On Tue, May 23, 2017 at 4:03 AM, Gunnar "Nick" Bluth < gunnar.bluth.ext...@elster.de> wrote: > Am 05/22/2017 um 09:57 PM schrieb Jeff Janes: > > > > create view view2 as select id, > > ( > > select md5 from thing_alias where thing_id=id > > order by priority desc limit 1 > > ) as

Re: [PERFORM] Log update query along with username who has executed the same.

2017-05-23 Thread Dinesh Chandra 12108
Thank you so much Rick, It’s working fine. Regards, Dinesh Chandra |Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida. -- Mobile: +91-9953975849 | Ext 1078 |dinesh.chan...@cyient.com

Re: [PERFORM] Log update query along with username who has executed the same.

2017-05-23 Thread Rick Otten
You need to include "%u" in the log_line_prefix setting in your postgresql.conf. Like this: log_line_prefix = '%m %d %h %u ' > > #log_line_prefix = '' # special values: > > # %a = application name > > # %u = user name > >

[PERFORM] Log update query along with username who has executed the same.

2017-05-23 Thread Dinesh Chandra 12108
Dear Expert, May you please provide the solution for below query. I have to create a log for all the update query executed in database along with its username who has executed that query. However, I am able to log all the update queries in my pg_log file but it's not showing particular user

Re: [PERFORM] select subquery versus join subquery

2017-05-23 Thread Gunnar "Nick" Bluth
Am 05/22/2017 um 09:57 PM schrieb Jeff Janes: > I need to make a view which decorates rows from a parent table with > aggregated values from a child table. I can think of two ways to write > it, one which aggregates the child table to make a new query table and > joins the parent to that, as