On 01/08/2019 15:10, Shital A wrote:
Hello,
We are working on development of an application with postgresql 9.6 as
backend. Application as a whole is expected to give an throughput of
100k transactions per sec. The transactions are received by DB from
component firing DMLs in ad-hoc fashion i
On 18/07/2019 23:51, mayank rupareliya wrote:
[...]
Thanks Andreas, David, Gavin
/Any particular reason for using varchar instead of text, for field?/ No
use UUID for the user_id.Agreed
/[...]/
/Use of text is preferred, but I can't see it making any significant
difference to performance --
On 17/07/2019 23:03, mayank rupareliya wrote:
[...]
Table and index are created using following query.
create table fields(user_id varchar(64), field varchar(64));
CREATE INDEX index_field ON public.fields USING btree (field);
[...]
Any particular reason for using varchar instead of text, for
On 17/04/2019 18:01, Jean-David Beyer wrote:
On 4/16/19 6:39 PM, Gavin Flower wrote:
I suspect that most things will run a little better with some swap space.
Not always.
$ free
total used free shared buffers cached
Mem: 16254616 13120960 3133656
On 15/04/2019 08:23, Gunther wrote:
For weeks now, I am banging my head at an "out of memory" situation.
There is only one query I am running on an 8 GB system, whatever I
try, I get knocked out on this out of memory. It is extremely
impenetrable to understand and fix this error. I guess I co
On 09/04/2019 08:02, legrand legrand wrote:
Rick Otten-2 wrote
On Mon, Apr 8, 2019 at 8:04 AM Julien Rouhaud <
rjuju123@
> wrote:
[...]
That said, none of this is on topic for the performance mailing list.
Please try to direct your questions to the right group next time.
Is "general" the corr
On 01/04/2019 23:20, Andrew Gierth wrote:
"tank" == tank zhang <6220...@qq.com> writes:
tank> smtoc| character varying(50) | | |
tank> Sort Key: smtoc
What is the output of SHOW lc_collate;
One of the most common reasons for slow sorting is that
