Hi
Is the table stats up to date on both?
https://www.postgresql.org/docs/current/planner-stats.html
Best regards,
Na-iem Dollie
On Mon, Oct 10, 2022 at 2:56 PM Kostas Papadopoulos <
kos...@methodosit.com.cy> wrote:
>
> I have two identical databases running in the same instance of Postgresql.
ckup for a particular database.
>
>
>
> Like that, we need to take the differential Backup in PostgreSQL. This is
> my primary need.
>
>
>
> *Thanks,*
>
> *Karthick Ramu*
>
>
>
>
>
> *From:* Daevor The Devoted [mailto:doll...@gmail.com]
> *Sent:*
Hi Karthick
I'm a little rusty on PG (it's been about a decade since I last worked
intensely with it), but I seem to remember that restoring with indexes can
be very slow. The faster approach is to restore *without* indexes, and then
create the indexes once the data restore is complete.
My knowle
+1
(+10 billion actually, but sadly, I'm only allowed a +1)
On Thu, Feb 6, 2020 at 4:55 AM Vik Fearing wrote:
> Hello,
>
> I proposed a patch to add %x to PROMPT1 and PROMPT2 by default in psql.
>
> The effect of this is:
>
> - nothing at all when not in a transaction,
> - adding a '*' when in
Hi
It is always exciting when someone encounters the internet for the first
time. There so much information available it can become quite overwhelming!
1) Can someone please send me a link of all companies using PostgreSQL ?
Such a list does not exist, but as someone else has mentioned, here
On Fri, Mar 2, 2018 at 12:05 AM, Gavin Flower wrote:
> On 02/03/18 06:47, Daevor The Devoted wrote:
>
>>
>> On Thu, Mar 1, 2018 at 2:07 PM, Rakesh Kumar > <mailto:rakeshkumar...@aol.com>> wrote:
>>
>>
>> >Adding a surrogate key to such a t
On Thu, Mar 1, 2018 at 10:36 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Thu, Mar 1, 2018 at 1:32 PM, marcelo wrote:
>
>> What´s the question?
>>
>>
> Whether the OP, who hasn't come back, knew they were starting a flame war
> by asking this question...
>
> There is no conte
On Thu, Mar 1, 2018 at 10:32 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Thu, Mar 1, 2018 at 1:24 PM, Ron Johnson wrote:
>
>> Why have the overhead of a second unique index? If it's "ease of joins",
>> then I agree with Francisco Olarte and use the business logic keys in your
On Thu, Mar 1, 2018 at 9:00 PM, Ron Johnson wrote:
> On 03/01/2018 12:32 PM, Daevor The Devoted wrote:
>
>
>
> On Thu, Mar 1, 2018 at 8:18 PM, Ron Johnson wrote:
>
>>
>> On 03/01/2018 11:47 AM, Daevor The Devoted wrote:
>>
>>
>> On Thu
On Thu, Mar 1, 2018 at 8:52 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Thu, Mar 1, 2018 at 11:32 AM, Daevor The Devoted
> wrote:
>
>> Could you perhaps elaborate on how a surrogate key allows one to insert
>> garbage into the table? I'm afra
On Thu, Mar 1, 2018 at 8:18 PM, Ron Johnson wrote:
> On 03/01/2018 11:47 AM, Daevor The Devoted wrote:
>
>
> On Thu, Mar 1, 2018 at 2:07 PM, Rakesh Kumar
> wrote:
>
>>
>> >Adding a surrogate key to such a table just adds overhead, although that
>> could b
On Thu, Mar 1, 2018 at 2:07 PM, Rakesh Kumar wrote:
>
> >Adding a surrogate key to such a table just adds overhead, although that
> could be useful
> >in case specific rows need updating or deleting without also modifying
> the other rows with
> >that same data - normally, only insertions and sel
t sure
I properly understand the use-case(s). Could you perhaps please give some
examples to help me understand? (I don't just mean some SQL code, I mean an
explanation of the business use-cases served by the code).
Kind regards,
Daevor, The Devoted
ing to it until you hit the problem. You may still not know why the
problem is happening, but you'll at least know where to focus any further
investigation.
Kind regards,
Daevor, The Devoted
14 matches
Mail list logo
