> 1,000,000 tables)
> 4:
> Create a database per user? (result: 5000 databases)
> 5:
> Is each user a separate schema? (result: 5000 schemas)
>
> Can you share your ideas with me?
> Thank you.
>
Best regards.
Samed YILDIRIM
Hello Aditya,
How many connections do you have on your PostgreSQL cluster? And, do your
webserver and database service run on the same machine/VM?
I would check system logs on the server on which PostgreSQL cluster run.
Best regards.
Samed YILDIRIM
On Wed, 1 Mar 2023 at 22:40, aditya desai
targets.
ALTER TABLE table ALTER COLUMN column SET STATISTICS 300;
https://www.postgresql.org/docs/14/runtime-config-query.html#GUC-DEFAULT-STATISTICS-TARGET
Best regards.
Samed YILDIRIM
On Tue, 7 Mar 2023 at 14:14, Praneel Devisetty
wrote:
> Hi,
>
> I have a query which is taking rough
. It doesn't mean you can't use any index and indexes won't
be used because it is a view, well, if you do it right.
https://www.postgresql.org/docs/current/pgtrgm.html
Best regards.
Samed YILDIRIM
On Sun, 22 Jan 2023 at 13:34, aditya desai wrote:
> Hi,
> Is there any way to improve perfo
? Or, are they generally closer to
the newest rows?
3. What is your speed limitation/expectation for the query execution time?
4. What is the version of PostgreSQL installation you use?
Best regards.
Samed YILDIRIM
On Mon, 9 Jan 2023 at 10:23, spiral wrote:
> Hello,
>
> We have a table c
Hello James,
Could you please add configurations of your PostgreSQL installations too?
I also wonder why you skip vacuuming (-n parameter) before starting of
tests.
Best regards.
Samed YILDIRIM
On Thu, 15 Dec 2022 at 10:22, James Pang (chaolpan)
wrote:
> Hi,
>
>We had some
ers are reserved for
PostgreSQL and there is no other service running on them.
Best regards.
Samed YILDIRIM
On Wed, 14 Dec 2022 at 20:12, Jordan Hurwich
wrote:
> Thanks for your thoughtful response Samed.
>
> I'm familiar with the article you linked to, and part of my surprise is
> that
g system cache,
> it's unlikely you'll find using more than 40% of RAM to work better than a
> smaller amount.
>
Best regards.
Samed YILDIRIM
On Tue, 13 Dec 2022 at 02:29, Jordan Hurwich
wrote:
> Hi everyone,
> I'm writing to ask about a correlation I was surprised to observe on o
Dear Mariel, 1,4. Could you please check all child tables whether they all have check constraints or not? Does your main table store any data? Also could you please share output of following command.show constraint_exclusion; 2. Filtering on comments_daily_247 table over log_server_id is not big