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..!
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
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*
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
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
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
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
>>
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
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
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
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
11 matches
Mail list logo