Groups > comp.databases.postgresql > #766

Re: Issues with backing up Postgres by copying folder

Path	csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From	Robert Klemme <shortcutter@googlemail.com>
Newsgroups	comp.databases.postgresql
Subject	Re: Issues with backing up Postgres by copying folder
Date	Thu, 11 May 2017 23:08:11 +0200
Lines	28
Message-ID	<enk25sFsq7qU1@mid.individual.net> (permalink)
References	<smBIA.407$xR7.221@fx28.iad> <20170419201146.02a1844344207bc63a19edcf@shallow.house> <HNzMA.23981$So6.1424@fx17.iad> <20170502000731.7d5f6e4492d851c4800bd500@shallow.house> <tS1OA.59756$So6.15017@fx17.iad> <20170503135752.28849ad7e804bc191bab0104@shallow.house> <ma%QA.48453$sS7.40155@fx40.iad>
Mime-Version	1.0
Content-Type	text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding	7bit
X-Trace	individual.net mI8lBeXBqvy0JN2kOAQ+hAyBpJdZaQnUp+liZL2WjBf5VfEf4=
Cancel-Lock	sha1:3i6CT+WoNudFy9zTZVokgUwFTec=
User-Agent	Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.8.0
In-Reply-To	<ma%QA.48453$sS7.40155@fx40.iad>
Xref	csiph.com comp.databases.postgresql:766

Show key headers only | View raw

On 11.05.2017 17:11, DFS wrote:
> On 5/3/2017 8:57 AM, Terry Shanks wrote:

>> There is a body of evidence to suggest SQLite is faster than many
>> multiuser rdbms' for general use but apparently CREATE INDEX is one
>> thing it does fall behind in.
>
> Apparently it creates an empty table with the new structure, copies the
> data from the old table, then deletes the old table.

I do not understand: what do you mean by "new structure"?  When creating 
an index there is no new structure.  Or are you somehow alluding to 
changing the primary key of a table?

https://sqlite.org/withoutrowid.html

> Extremely inefficient.

That would be the case.  I doubt though that SQLite does it for every 
index creation.

Cheers

	robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-04-15 23:17 -0400
  Re: Issues with backing up Postgres by copying folder Terry Shanks <deep@shallow.house> - 2017-04-19 20:11 +0100
    Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-04-28 00:45 -0400
      Re: Issues with backing up Postgres by copying folder Terry Shanks <deep@shallow.house> - 2017-05-02 00:07 +0100
        Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-02 11:48 -0400
          Re: Issues with backing up Postgres by copying folder Dimitri Fontaine <dimitri.fontaine@schibsted.com> - 2017-05-03 09:16 +0200
            Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-03 16:07 -0400
            Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-20 20:01 -0400
              Re: Issues with backing up Postgres by copying folder Dimitri Fontaine <dimitri.fontaine@schibsted.com> - 2017-05-21 13:46 +0200
                Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-21 08:48 -0400
                Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-31 07:29 -0400
                Re: Issues with backing up Postgres by copying folder Dimitri Fontaine <dimitri.fontaine@schibsted.com> - 2017-05-31 14:26 +0200
                Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-31 09:52 -0400
                Re: Issues with backing up Postgres by copying folder Dimitri Fontaine <dimitri.fontaine@schibsted.com> - 2017-05-31 16:27 +0200
          Re: Issues with backing up Postgres by copying folder Terry Shanks <deep@shallow.house> - 2017-05-03 13:57 +0100
            Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-05-11 11:11 -0400
              Re: Issues with backing up Postgres by copying folder Robert Klemme <shortcutter@googlemail.com> - 2017-05-11 23:08 +0200
    Re: Issues with backing up Postgres by copying folder Gordon Gekko <greed@is.good.invalid> - 2017-05-08 02:39 +0000
  Re: Issues with backing up Postgres by copying folder Rainer Weikusat <rweikusat@talktalk.net> - 2017-04-23 22:15 +0100
    Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-04-28 00:42 -0400
      Re: Issues with backing up Postgres by copying folder Rainer Weikusat <rweikusat@talktalk.net> - 2017-04-28 12:39 +0100
        Re: Issues with backing up Postgres by copying folder DFS <nospam@dfs.com> - 2017-04-28 11:16 -0400
          Re: Issues with backing up Postgres by copying folder Rainer Weikusat <rweikusat@talktalk.net> - 2017-04-28 16:42 +0100
            Re: Issues with backing up Postgres by copying folder Rainer Weikusat <rweikusat@talktalk.net> - 2017-04-28 16:48 +0100
              Re: Issues with backing up Postgres by copying folder Terry Shanks <deep@shallow.house> - 2017-05-02 00:00 +0100
              Re: Issues with backing up Postgres by copying folder Mladen Gogala <gogala.mladen@gmail.com> - 2017-05-08 02:41 +0000

csiph-web