Hi Pavlos
This is my understanding of why you were not able to run the query fast
enough after the vacuum analyze. This is possibly what would have happened:
1. The relation has 5 million expired URLs and 5 thousand non-expired
URLs
2. Assuming that the table only has 5 million and 5
Hi Mehmet,
On Wed, 31 Jan 2024 at 13:33, Mehmet COKCEVIK
wrote:
> Hi,
> We want to work with PostgreSQL in our new project. I need your opinion on
> the best way to create a database.
>
First of all, congratulations on your decision to use PostgreSQL for your
new project. :)
> Description of
Hi,
We want to work with PostgreSQL in our new project. I need your opinion on
the best way to create a database.
Description of our Project:
It will be in Client/Server Architecture. Windows Application users will
access the server as clients and they are all in different locations. There
will