Condor wrote:
> Thank you for your answer.
>
> It's seems this is a weak spot of Postgres.
It isn't.
If your secondary storage goes bad, a database is supposed to fail.
That's why you take backups.
Yours,
Laurenz Albe
--
+43-670-6056265
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26, A-2700
On 16-11-2018 19:40, Alexey Bashtanov wrote:
Yes, I know. My question is: Did the pg server will start at all if
the NVME / table space somehow is broken and indexes is unable to be
loaded, not how to drop an index.
Since the Postgre server is not starting at all maybe I can try
dropping my ind
Yes, I know. My question is: Did the pg server will start at all if
the NVME / table space somehow is broken and indexes is unable to be
loaded, not how to drop an index.
Since the Postgre server is not starting at all maybe I can try
dropping my indexes on my pocket calculator all day long.
On 07-11-2018 08:52, Tony Shelver wrote:
Did you check the documentation for alter index?
https://www.postgresql.org/docs/10/sql-alterindex.html
You could create a script file (plenty of examples on the internet on
generating these) and then run through psql or whatever.
Also, if you just have
Did you check the documentation for alter index?
https://www.postgresql.org/docs/10/sql-alterindex.html
You could create a script file (plenty of examples on the internet on
generating these) and then run through psql or whatever.
Also, if you just have a few indexes to move, you could use (for e
Le mar. 6 nov. 2018 20:49, Condor a écrit :
> On 05-11-2018 10:56, Condor wrote:
> > Hello,
> >
> > I have a database that use index on different table space (nvme). I
> > read documentation about table space and understand table space cannot
> > be treated as an autonomous collection of data fil
On 05-11-2018 10:56, Condor wrote:
Hello,
I have a database that use index on different table space (nvme). I
read documentation about table space and understand table space cannot
be treated as an autonomous collection of data files.
My question is: Is this always true ? I mean if I have table
Hello,
I have a database that use index on different table space (nvme). I read
documentation about table space and understand table space cannot be
treated as an autonomous collection of data files.
My question is: Is this always true ? I mean if I have table .. okay
here is example:
crea
