When comparing DPKG (Debian Package Manager) vs Pacman, the Slant community recommends Pacman for most people. In the question“What are the best Linux package managers?” Pacman is ranked 1st while DPKG (Debian Package Manager) is ranked 4th. The most important reason people chose Pacman is:
Pacman is objectively one of the fastest package managers around. This is because it's very minimalistic and it installs only prebuilt packages.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro De facto package manager / widely used
Due the popularity of Ubuntu, Debian and Linux Mint it is almost certain that you find the package you want as a pre-built deb package.
Pro Great multiarch support
DKPG has one of the best multiarch support you can easily add new architectures with dpkg --add-architecture $ARCH to install foreign architectures.
Pro Follows the UNIX philosophy
DPKG and it frontends follow strictly the UNIX philosophy that one package should do one thing well.
eg:
Dpkg: does simple package management
APT and aptitude : adds repository and dependency tracking
debconf: does configuration
synaptic: allows mouse interaction to all apt/aptitude options
Pro Fast
DPKG isn't as bloated as other package managers since it is only made for local package management.
Pro Very easy to create packages
There are plenty of helpers to easily create packages.
You just need to create 5 files: source/format, compat, rules, control & changelog and run dpkg-buildpackage.
Pro Standard archives
Deb packages are simple ar archives with additional tar, lzma, bzip, gzip support.
Pro Plenty of frontends
You can use apt, aptitude, cupt, debdelta or apt-build on the terminal.
Pro User interaction
It is possible to interact/ask questions to all pre and post install scripts. This makes it possibe to add questions for package configuration or to display EULA/License screens that have to be accepted before installation.
Pro You can create deb packages on almost all linux distributions
This makes maintenance and support easy.

Pro Fast
Pacman is objectively one of the fastest package managers around. This is because it's very minimalistic and it installs only prebuilt packages.
Pro Packaging signing keyring and mirror list
Both are also provided through packages which keeps them up to date.
Pro Advanced when you want it
Pacman does not overwrite modified configuration files. Instead, it saves a .pacnew file for it which you can later merge at your leisure.
Pro Manages dependencies reliably

Pro Simple syntax
Pacman has a relatively simple syntax which is easy to get used to. For example: pacman -Syu
to update, pacman -S foo
to install etc...
Commands are not long and there are not many different commands to learn by heart.
Pro Pacman hooks add power and flexibility
Hooks are scripts that can run automatically before and after Pacman transactions like installation and removal of packages. For example, Pacman hooks can be used to automatically create system users and files during the installation of packages. Pacman hooks can also be used to delete configuration files and clear caches during the removal of packages.

Pro Zstd compression
Uses Zstd compression for fast downloads & updates.
Pro Many wrappers available which extend functionality
Here are three examples: Powerpill, Yay, and Octopi. Powerpill extends Pacman by enabling asynchronous downloads of packages from multiple mirrors using Aria2 and Reflector. Yay extends Pacman, by enabling automatic download, compilation, and installation of packages from the AUR. Octopi extends Pacman with a GUI frontend written in Qt.
Pro Synchronizes package lists with the master server
It allows the system to always be up to date.
Pro Supports colored output
And looks cleaner and nicer with such thing enabled. Simply find and uncomment "Color" option in /etc/pacman.conf or add it yourself if it doesn't exists.
Pro Easy to create custom repositories
Pacman makes it fairly easy and straightforward to create your own repository with signatures.
Pro Can be made to use any downloader
Allows to change its downloader from internal to any other like wget or aira2.
Pro Simple and easy to use with custom repositories
The instructions and configurations for using a custom local or remote repositories are pretty simple and straightforward.
Pro Kernel build ordered
Pro Supports deltas
However default Arch Linux mirror servers does not provide deltas, so it is not so useful like with DNF.
Cons
Con Does not work well with packagekit
Since packagekit was developed with rpm in mind it does not support all dpkg features.
Con Package creation needs more than one file
A debian package needs at least the following files to build it with debhelper
debian/source/format - deb format
debian/changelog - changelog file with version number and dae etc.
debian/compat - debian package version
debian/control - package information, dependencies & co
debian/copyright - license information
debian/rules - the make file to build the package
However the really important files are control, changelog and rules all other are generic.
Con Bad handling of conflicts
Relying on the entire system being updated to the exact same version, making the famed rolling-release model ironically even worse in practice than the traditional version model.
Con Unintuitive syntax
Pacman has a difficult syntax and commands to remember.
Con Naive
For example, it doesn't allow you to purge (remove package and its configuration files).
Con No official way to downgrade packages
This is related to it not supporting partial system upgrades. The very same reason prevents it from downgrading a particular package easily. Doing so can easily result in conflicts and may require a system downgrade or downgrade of multiple packages.
Con No partial upgrades
Pacman just doesn't support partial upgrades. It has to always be system upgrade and never package upgrade.
Con Poor Multiarch support
can not install regular foreign arch packages alongside and needs specific nade subarch packages.
Con Doesn't always clean up after itself
Pacman leaves new configuration versions around and generally doesn't handle file conflicts smoothly.
Con Not KISS
It is not simple or does follow the UNIX philosophy instead it tries too much at the same time which results in slowness and errors.
Con Bloated
It is over complicated and bloated compared to other *NIX package managers like dpkg, rpm or pkgsrc. For example, they follow the Unix philosophy and do "one" thing well, which is to install local packages and use other frontends to configure, remote install or to search for packages/files. Pacman, however, tries to do all those tasks in one app, which adds some flaws.
Con Painfully slow
It takes ages to update the system compared to dpkg or rpm, which due its poor performance by unpacking very large packages with many files to the filesystem.
Con No parallelization
Neither downloads nor processing can be set to run in parallel.
Con You can not create pacman packages under a non-pacman distribution
For example on fedora/suse/debian/ubuntu, you can easily create rpm and deb packages, but you can not create pacman packages, which makes it uncomfortable to support arch/pacman packages.
