Re: [GENERAL] factor effecting performance of postgres

2017-01-19 Thread Adrian Klaver
On 01/19/2017 12:46 PM, PAWAN SHARMA wrote: Hello All, Please stop cross-posting to more then one mailing list. I am new to postgres using OS: linux 7.2 and postgres : postgresql-9.5.4-2. what are the factor's affecting postgres performance? and to overcome them. Please suggest..!

Re: [GENERAL] factor effecting performance of postgres

2017-01-19 Thread John R Pierce
On 1/19/2017 12:46 PM, PAWAN SHARMA wrote: I am new to postgres using OS: linux 7.2 and postgres : postgresql-9.5.4-2. what are the factor's affecting postgres performance? and to overcome them. * CPU speed, * cpu core count (if you have significant concurrency), * memory size, * disk

[GENERAL] factor effecting performance of postgres

2017-01-19 Thread PAWAN SHARMA
Hello All, I am new to postgres using OS: linux 7.2 and postgres : postgresql-9.5.4-2. what are the factor's affecting postgres performance? and to overcome them. Please suggest..! *-Pawan*

[GENERAL] What happens when a large table is alterted from UNLOGGED to LOGGED

2017-01-19 Thread Rakesh Kumar
In order to speed up loading a set of 12 tables, I have declared them as UNLOGGED. As per documentation, an unlogged table will also have unlogged indices. Question: When the table is converted back to logged, does PG rebuild all indices before marking them as logged. Also what about FKY

Re: [GENERAL] Moving from 9.5 to 9.6

2017-01-19 Thread Adrian Klaver
On 01/19/2017 03:58 AM, PAWAN SHARMA wrote: Hi All, I am using postgres 9.5 enterprise and if I want to move or upgrade it You are going to be more specific about what you mean about Postgres 9.5 enterprise. Where did you get it? Also what do you mean by move it? 9.6 enterprise version

Re: [GENERAL] Combining count() and row_number() as window functions

2017-01-19 Thread Stephen Frost
Tom, * Tom Lane (t...@sss.pgh.pa.us) wrote: > Thomas Kellerer writes: > > I assumed that the count() wouldn't increase the runtime of the query as > > the result of the row_number() can be used to calculate that. > > No such knowledge exists in Postgres. Given our general

Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5

2017-01-19 Thread Merlin Moncure
On Thu, Jan 19, 2017 at 1:28 AM, Tomas Vondra wrote: > On 01/19/2017 06:21 AM, Merlin Moncure wrote: >> > ... >> >> >> yes. Either way, I would like to very much understand how server is >> preferring 3m cost plan to 2.6k cost plan or is otherwise unable to >>

Re: [GENERAL] Combining count() and row_number() as window functions

2017-01-19 Thread Tom Lane
Thomas Kellerer writes: > I assumed that the count() wouldn't increase the runtime of the query as the > result of the row_number() can be used to calculate that. No such knowledge exists in Postgres. Given our general approach in which functions (including window

Re: [GENERAL] migrate Sql Server database to PostgreSql

2017-01-19 Thread Kenneth Marshall
On Thu, Jan 19, 2017 at 03:29:34PM +1100, Venkata B Nagothi wrote: > On Thu, Jan 19, 2017 at 6:17 AM, PAWAN SHARMA > wrote: > > > Hello All, > > > > I am using postgres 9.5 enterprise edition. > > > > i want to to how to migrate Sql Server database to PostgreSql. what

[GENERAL] Combining count() and row_number() as window functions

2017-01-19 Thread Thomas Kellerer
I was playing around with a query that essentially looked something like this: select row_number() over (order by foo_date) as rn, count(*) over () as total_count, f.* from foo f; (The actual query limits the output based on the row_number() for pagination

[GENERAL] Moving from 9.5 to 9.6

2017-01-19 Thread PAWAN SHARMA
Hi All, I am using postgres 9.5 enterprise and if I want to move or upgrade it 9.6 enterprise version then what are steps required and is it done by any patching or we have to completely upgrade from. 9.5 to 9.6 -Pawan